this homework for Adrian Monroe

profileMikey77
stock_portfolio_final_revised.xlsx
Home>Business & Finance homework help>this homework for Adrian Monroe

FBDOW

FB/DOW

126.62 127.35 128.34 127.87 127.92 127.55 127.04 128.93 130.46 131.47999999999999 132.78 132.18 130.97999999999999 130.32 133.22999999999999 130.84 130.97999999999999 132.06 131.84 134.19999999999999 134.13999999999999 134.19 134.05000000000001 133.87 133.44 133.84 133.53 133.53 133.72 136.1 135.36000000000001 135.44 136.41 135.54 135.78 136.76 136.97999999999999 137.34 137.57 138.1 138.24 138.84 139.6 139.32 139.66999999999999 139.99 139.84 139.94 138.51 139.94999999999999 139.53 140.34 140.32 141.76 142.65 142.41 142.05000000000001 142.28 141.72999999999999 141.85 141.16999999999999 140.78 141.04 139.91999999999999 139.58000000000001 139.62 139.38999999999999 141.41999999999999 140.96 142.27000000000001 19891 19885.73 19826.77 19804.72 19804.72 19732.400000000001 19827.25 19799.849999999999 20076.25 20068.509999999998 20100.91 20093.78 19971.13 19864.09 19890.939999999999 19884.91 20071.46 20052.419999999998 20090.29 20054.34 20172.400000000001 20269.37 20412.16 20546.34 20611.86 20619.77 20619.77 20624.05 20743 20775.599999999999 20810.32 20821.759999999998 20837.439999999999 20812.240000000002 20934.78 21002.97 21003.34 20934.84 20912.46 20873.29 20858.189999999999 20873.34 20881.48 20837.37 20883.830000000002 20934.55 20914.62 20905.86 20668.009999999998 20661.3 20656.580000000002 20656.580000000002 20550.98 20701.5 20659.32 20728.490000000002 20663.22 20650.21 20689.240000000002 20648.150000000001 20662.95 20656.099999999999 20658.02 20651.3 20591.86 20561.689999999999 20453.25 20636.919999999998 20523.28 20404.490000000002

TWTRDOW

TWTRDOW

17.38 17.14 17.25 16.96 17.11 16.79 16.579999999999998 16.61 16.649999999999999 16.73 16.809999999999999 16.57 16.940000000000001 17.62 17.239999999999998 17.78 17.61 17.93 18.260000000000002 18.72 16.41 15.58 15.81 16.43 16.739999999999998 16.350000000000001 16.350000000000001 16.62 16.420000000000002 16.079999999999998 16.03 15.98 16.059999999999999 15.77 15.79 15.79 15.45 15.42 15.39 15.34 15.22 15.22 15.21 15.32 15.26 15.19 15.08 15.09 14.54 14.98 14.93 15.14 14.99 14.94 15.04 14.92 14.95 14.84 14.69 14.53 14.39 14.29 14.36 14.31 14.42 14.49 14.3 14.4 14.44 14.54 19891 19885.73 19826.77 19804.72 19804.72 19732.400000000001 19827.25 19799.849999999999 20076.25 20068.509999999998 20100.91 20093.78 19971.13 19864.09 19890.939999999999 19884.91 20071.46 20052.419999999998 20090.29 20054.34 20172.400000000001 20269.37 20412.16 20546.34 20611.86 20619.77 20619.77 20624.05 20743 20775.599999999999 20810.32 20821.759999999998 20837.439999999999 20812.240000000002 20934.78 21002.97 21003.34 20934.84 20912.46 20873.29 20858.189999999999 20873.34 20881.48 20837.37 20883.830000000002 20934.55 20914.62 20905.86 20668.009999999998 20661.3 20656.580000000002 20656.580000000002 20550.98 20701.5 20659.32 20728.490000000002 20663.22 20650.21 20689.240000000002 20648.150000000001 20662.95 20656.099999999999 20658.02 20651.3 20591.86 20561.689999999999 20453.25 20636.919999999998 20523.28 20404.490000000002

MSFTDOW

MSFT/DOW

62.61 62.59 62.7 62.53 62.5 62.3 62.74 62.96 63.47 63.68 64.27 65.78 65.13 64.650000000000006 63.58 63.17 63.68 63.64 63.43 63.34 64.06 64 64.33 64.44 64.53 64.52 64.62 64.62 64.489999999999995 64.36 64.62 64.62 64.23 63.98 64 64.010000000000005 64.27 64.349999999999994 64.67 64.69 64.73 64.709999999999994 64.709999999999994 64.41 64.58 64.64 64.87 64.930000000000007 64.209999999999994 65.03 64.87 64.98 65.099999999999994 65.290000000000006 65.47 65.709999999999994 65.86 65.55 65.73 65.56 65.73 65.680000000000007 65.53 65.48 65.23 65.290000000000006 64.95 65.48 65.39 65.040000000000006 19891 19885.73 19826.77 19804.72 19804.72 19732.400000000001 19827.25 19799.849999999999 20076.25 20068.509999999998 20100.91 20093.78 19971.13 19864.09 19890.939999999999 19884.91 20071.46 20052.419999999998 20090.29 20054.34 20172.400000000001 20269.37 20412.16 20546.34 20611.86 20619.77 20619.77 20624.05 20743 20775.599999999999 20810.32 20821.759999999998 20837.439999999999 20812.240000000002 20934.78 21002.97 21003.34 20934.84 20912.46 20873.29 20858.189999999999 20873.34 20881.48 20837.37 20883.830000000002 20934.55 20914.62 20905.86 20668.009999999998 20661.3 20656.580000000002 20656.580000000002 20550.98 20701.5 20659.32 20728.490000000002 20663.22 20650.21 20689.240000000002 20648.150000000001 20662.95 20656.099999999999 20658.02 20651.3 20591.86 20561.689999999999 20453.25 20636.919999999998 20523.28 20404.490000000002

NKEDOW

NKE/DOW

52.67 52.58 52.92 53.65 53.27 52.93 53.2 53.24 53.58 53.86 53.65 53.19 53.08 52.9 52.03 52.8 52.36 52.8 52.81 53.88 55.31 56.22 56.09 56.43 56.64 56.29 56.29 56.75 57.36 58.24 57.39 57.86 57.96 57.16 57.55 57.8 57.79 57.35 57.2 56.55 56.36 56.47 56.67 57.28 57.59 57.6 57.8 58.68 58.01 53.82 55.37 56.36 55.93 56.62 56.68 56.04 55.73 55.65 55.04 54.98 55.14 55.11 54.9 54.92 55.57 55.41 55.34 56.24 56.11 55.86 19891 19885.73 19826.77 19804.72 19804.72 19732.400000000001 19827.25 19799.849999999999 20076.25 20068.509999999998 20100.91 20093.78 19971.13 19864.09 19890.939999999999 19884.91 20071.46 20052.419999999998 20090.29 20054.34 20172.400000000001 20269.37 20412.16 20546.34 20611.86 20619.77 20619.77 20624.05 20743 20775.599999999999 20810.32 20821.759999999998 20837.439999999999 20812.240000000002 20934.78 21002.97 21003.34 20934.84 20912.46 20873.29 20858.189999999999 20873.34 20881.48 20837.37 20883.830000000002 20934.55 20914.62 20905.86 20668.009999999998 20661.3 20656.580000000002 20656.580000000002 20550.98 20701.5 20659.32 20728.490000000002 20663.22 20650.21 20689.240000000002 20648.150000000001 20662.95 20656.099999999999 20658.02 20651.3 20591.86 20561.689999999999 20453.25 20636.919999999998 20523.28 20404.490000000002

GOOGDOW

GOOG/DOW

806.36 807.45 807.88 804.61 806.07 802.17 805.02 819.13 819.33 835.37 832.15 823.31 802.32 796.79 795.69 798.53 801.49 801.34 806.97 808.38 809.56 813.67 819.24 819.03 818.98 824.16 828.07 828.07 831.66 830.76 831.33 828.64 829.28 823.21 827.45 830.36 832.76 834.34 834.79 835.46 838.68 839.48 845.54 845.62 847.35 848.78 852.18 848.4 830.46 829.59 817.58 814.43 819.51 820.92 831.41 831.5 829.56 838.55 834.57 831.41 827.88 824.67 824.73 823.35 824.32 822.14 823.56 837.17 836.82 838.21 19891 19885.73 19826.77 19804.72 19804.72 19732.400000000001 19827.25 19799.849999999999 20076.25 20068.509999999998 20100.91 20093.78 19971.13 19864.09 19890.939999999999 19884.91 20071.46 20052.419999999998 20090.29 20054.34 20172.400000000001 20269.37 20412.16 20546.34 20611.86 20619.77 20619.77 20624.05 20743 20775.599999999999 20810.32 20821.759999999998 20837.439999999999 20812.240000000002 20934.78 21002.97 21003.34 20934.84 20912.46 20873.29 20858.189999999999 20873.34 20881.48 20837.37 20883.830000000002 20934.55 20914.62 20905.86 20668.009999999998 20661.3 20656.580000000002 20656.580000000002 20550.98 20701.5 20659.32 20728.490000000002 20663.22 20650.21 20689.240000000002 20648.150000000001 20662.95 20656.099999999999 20658.02 20651.3 20591.86 20561.689999999999 20453.25 20636.919999999998 20523.28 20404.490000000002

PortfolioDOW

Portfolio/DOW

19891 19885.73 19826.77 19804.72 19804.72 19732.400000000001 19827.25 19799.849999999999 20076.25 20068.509999999998 20100.91 20093.78 19971.13 19864.09 19890.939999999999 19884.91 20071.46 20052.419999999998 20090.29 20054.34 20172.400000000001 20269.37 20412.16 20546.34 20611.86 20619.77 20619.77 20624.05 20743 20775.599999999999 20810.32 20821.759999999998 20837.439999999999 20812.240000000002 20934.78 21002.97 21003.34 20934.84 20912.46 20873.29 20858.189999999999 20873.34 20881.48 20837.37 20883.830000000002 20934.55 20914.62 20905.86 20668.009999999998 20661.3 20656.580000000002 20656.580000000002 20550.98 20701.5 20659.32 20728.490000000002 20663.22 20650.21 20689.240000000002 20648.150000000001 20662.95 20656.099999999999 20658.02 20651.3 20591.86 20561.689999999999 20453.25 20636.919999999998 20523.28 20404.490000000002 99997.382800000007 99822.974699999992 100280.8349 100014.67569999999 100077.51689999999 99361.122600000002 99352.668600000005 100121.1102 100705.78289999999 101530.14790000001 101856.41529999999 101573.91650000001 101040.19680000001 101359.63500000001 100682.54730000001 101158.2978 101054.0289 101743.4341 102164.7714 103479.39719999998 101613.94810000001 101095.02990000001 101531.77700000002 102375.8462 102771.91099999999 102378.6661 102458.6136 102943.98730000001 103022.98179999999 103277.95419999999 102877.9621 102944.817 103119.3509 102114.04490000001 102434. 59950000001 102759.6829 102541.9541 102461.95599999999 102520.1848 102322.54759999999 102227.05739999999 102377.0478 102711.8143 102931.952 103133.1115 103161.5306 103244.9908 103531.86929999999 101743.7671 101126.88310000001 101242.6142 101945.15239999999 101770.4181 102297.997 102894.08189999999 102553.9607 102413.712 102417.00599999999 101884.68700000001 101564.065 101323.06999999999 101039.42290000001 101034.8732 100757.83010000001 101021.7236 101012.94129999999 100657.9963 101942.28899999999 101828.8688 101978.5963

Data Analysis

SUMMARY OUTPUT Facebook SUMMARY OUTPUT Twitter SUMMARY OUTPUT Microsoft SUMMARY OUTPUT Nike SUMMARY OUTPUT Google
Regression Statistics Regression Statistics Regression Statistics Regression Statistics Regression Statistics
Multiple R 0.0174887873 Multiple R 0.0290931682 Multiple R 0.3998019605 Multiple R 0.0104244844 Multiple R 0.2036794532
R Square 0.0003058577 R Square 0.0008464124 R Square 0.1598416076 R Square 0.0001086699 R Square 0.0414853196
Adjusted R Square -0.0135787832 Adjusted R Square -0.0130307207 Adjusted R Square 0.1481727411 Adjusted R Square -0.0137787097 Adjusted R Square 0.0281726157
Standard Error 0.0069809827 Standard Error 0.0235547692 Standard Error 0.0055736496 Standard Error 0.0128619736 Standard Error 0.0072788255
Observations 74 Observations 74 Observations 74 Observations 74 Observations 74
ANOVA ANOVA ANOVA ANOVA ANOVA
df SS MS F Significance F df SS MS F Significance F df SS MS F Significance F df SS MS F Significance F df SS MS F Significance F
Regression 1 0.0000010735 0.0000010735 0.0220284906 0.8824262297 Regression 1 0.0000338408 0.0000338408 0.0609933209 0.8056356264 Regression 1 0.0004255401 0.0004255401 13.6981262753 0.0004170186 Regression 1 0.0000012945 0.0000012945 0.0078250814 0.9297570679 Regression 1 0.0001651014 0.0001651014 3.1162204142 0.0817565322
Residual 72 0.0035088566 0.0000487341 Residual 72 0.0399475551 0.0005548272 Residual 72 0.002236721 0.0000310656 Residual 72 0.0119109862 0.0001654304 Residual 72 0.0038146537 0.0000529813
Total 73 0.0035099301 Total 73 0.0399813959 Total 73 0.0026622611 Total 73 0.0119122807 Total 73 0.0039797551
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.0020837904 0.0008209354 2.5383122276 0.0133021914 0.0004472856 0.0037202952 0.0004472856 0.0037202952 Intercept -0.0002887186 0.0027699458 -0.1042325768 0.9172745911 -0.0058105047 0.0052330675 -0.0058105047 0.0052330675 Intercept 0.0008261686 0.0006554387 1.260481857 0.2115652922 -0.0004804246 0.0021327618 -0.0004804246 0.0021327618 Intercept 0.0008097545 0.0015125162 0.535369124 0.5940444567 -0.0022053915 0.0038249004 -0.0022053915 0.0038249004 Intercept 0.0008754623 0.0008559605 1.0227835585 0.3098344363 -0.0008308638 0.0025817885 -0.0008308638 0.0025817885
X Variable 1 -0.0266387315 0.1794821116 -0.1484199803 0.8824262297 -0.3844297819 0.3311523189 -0.3844297819 0.3311523189 X Variable 1 0.1495631506 0.6055966518 0.2469682588 0.8056356264 -1.0576717108 1.356798012 -1.0576717108 1.356798012 X Variable 1 -0.5303650022 0.1432993681 -3.7010979824 0.0004170186 -0.8160270716 -0.2447029327 -0.8160270716 -0.2447029327 X Variable 1 0.0292520735 0.3306832706 0.0884594901 0.9297570679 -0.6299529786 0.6884571255 -0.6299529786 0.6884571255 X Variable 1 -0.3303543321 0.1871396971 -1.7652819645 0.0817565322 -0.7034105001 0.0427018359 -0.7034105001 0.0427018359

Stock Portfolio

Column1 Facebook (FB) Column2 Column3 Column1 Twitter (TWTR) Column2 Column3 Column1 MSFT Column2 Column3 Column1 NKE Column2 Column3 Column1 GOOG Column2 Column3 S&P500 Column1 DOW Column2 Total Value of Stock Column3 Column1
Date Number of Shares Closing Price Daily Value of Stock Daily Return Number Of Shares Closing Price Daily Value of Stock Daily Return Number Of Shares Closing Price Daily Value of Stock Daily Return Number Of Shares Closing Price Daily Value of Stock Daily Return Number Of Shares Closing Price Daily Value of Stock Daily Return Closing Price Daily return Closing Price Daily Return Daily Return
1-12-17 157.95 $126.62 $19,999.63 1150.75 $17.38 $20,000.04 319.44 $62.61 $20,000.14 -$0.00032 379.72 $52.67 $19,999.85 24.8 $806.36 $19,997.73 2,270.44 -0.00047127 $99,997.38 0.0017472
1-13-17 157.95 $127.35 $20,114.93 $0.00577 1150.75 $17.14 $19,723.86 -$0.01381 319.44 $62.59 $19,993.75 $0.00176 379.72 $52.58 $19,965.68 -$0.00171 24.8 $807.45 $20,024.76 $0.00135 2,271.51 0.00159365 19,891.00 0.0002650142 $99,822.97 -0.0045658
1-17-17 157.95 $128.34 $20,271.30 $0.00777 1150.75 $17.25 $19,850.44 $0.00642 319.44 $62.70 $20,028.89 -$0.00271 379.72 $52.92 $20,094.78 $0.00647 24.8 $807.88 $20,035.42 $0.00053 2,267.89 -0.00176375 19,885.73 0.0029737572 $100,280.83 0.0026612
1-18-17 157.95 $127.87 $20,197.07 -$0.00366 1150.75 $16.96 $19,516.72 -$0.01681 319.44 $62.53 $19,974.58 -$0.00048 379.72 $53.65 $20,371.98 $0.01379 24.8 $804.61 $19,954.33 -$0.00405 2,271.89 0.00000000 19,826.77 0.001113371 $100,014.68 -0.0006279
1-19-17 157.95 $127.92 $20,204.96 $0.00039 1150.75 $17.11 $19,689.33 $0.00884 319.44 $62.50 $19,965.00 -$0.00320 379.72 $53.27 $20,227.68 -$0.00708 24.8 $806.07 $19,990.54 $0.00181 2,271.89 0.00360933 19,804.72 0 $100,077.52 0.0072100
1-20-17 157.95 $127.55 $20,146.52 -$0.00289 1150.75 $16.79 $19,321.09 -$0.01870 319.44 $62.30 $19,901.11 $0.00706 379.72 $52.93 $20,098.58 -$0.00638 24.8 $802.17 $19,893.82 -$0.00484 2,263.69 -0.00336619 19,804.72 0.0036650382 $99,361.12 0.0000851
1-23-17 157.95 $127.04 $20,065.97 -$0.00400 1150.75 $16.58 $19,079.44 -$0.01251 319.44 $62.74 $20,041.67 $0.00351 379.72 $53.20 $20,201.10 $0.00510 24.8 $805.02 $19,964.50 $0.00355 2,271.31 0.00269008 19,732.40 -0.0047838202 $99,352.67 -0.0076751
1-24-17 157.95 $128.93 $20,364.49 $0.01488 1150.75 $16.61 $19,113.96 $0.00181 319.44 $62.96 $20,111.94 $0.00810 379.72 $53.24 $20,216.29 $0.00075 24.8 $819.13 $20,314.42 $0.01753 2,265.20 -0.01475808 19,827.25 0.0013838489 $100,121.11 -0.0058058
1-25-17 157.95 $130.46 $20,606.16 $0.01187 1150.75 $16.65 $19,159.99 $0.00241 319.44 $63.47 $20,274.86 $0.00331 379.72 $53.58 $20,345.40 $0.00639 24.8 $819.33 $20,319.38 $0.00024 2,298.63 0.00011311 19,799.85 -0.0137675114 $100,705.78 -0.0081194
1-26-17 157.95 $131.48 $20,767.27 $0.00782 1150.75 $16.73 $19,252.05 $0.00480 319.44 $63.68 $20,341.94 $0.00927 379.72 $53.86 $20,451.72 $0.00523 24.8 $835.37 $20,717.18 $0.01958 2,298.37 0.00073530 20,076.25 0.0003856789 $101,530.15 -0.0032032
1-27-17 157.95 $132.78 $20,972.60 $0.00989 1150.75 $16.81 $19,344.11 $0.00478 319.44 $64.27 $20,530.41 $0.02349 379.72 $53.65 $20,371.98 -$0.00390 24.8 $832.15 $20,637.32 -$0.00385 2,296.68 0.00086647 20,068.51 -0.0016118673 $101,856.42 0.0027812
1-30-17 157.95 $132.18 $20,877.83 -$0.00452 1150.75 $16.57 $19,067.93 -$0.01428 319.44 $65.78 $21,012.76 -$0.00988 379.72 $53.19 $20,197.31 -$0.00857 24.8 $823.31 $20,418.09 -$0.01062 2,294.69 0.00600953 20,100.91 0.0003548362 $101,573.92 0.0052823
1-31-17 157.95 $130.98 $20,688.29 -$0.00908 1150.75 $16.94 $19,493.71 $0.02233 319.44 $65.13 $20,805.13 -$0.00737 379.72 $53.08 $20,155.54 -$0.00207 24.8 $802.32 $19,897.54 -$0.02549 2,280.90 0.00089000 20,093.78 0.0061413651 $101,040.20 -0.0031515
2-1-17 157.95 $130.32 $20,584.04 -$0.00504 1150.75 $17.62 $20,276.22 $0.04014 319.44 $64.65 $20,651.80 -$0.01655 379.72 $52.90 $20,087.19 -$0.00339 24.8 $796.79 $19,760.39 -$0.00689 2,278.87 -0.00029839 19,971.13 0.0053886184 $101,359.64 0.0067250
2-2-17 157.95 $133.23 $21,043.68 $0.02233 1150.75 $17.24 $19,838.93 -$0.02157 319.44 $63.58 $20,310.00 -$0.00645 379.72 $52.03 $19,756.83 -$0.01645 24.8 $795.69 $19,733.11 -$0.00138 2,279.55 -0.00057029 19,864.09 -0.0013498608 $100,682.55 -0.0047030
2-3-17 157.95 $130.84 $20,666.18 -$0.01794 1150.75 $17.78 $20,460.34 $0.03132 319.44 $63.17 $20,179.02 $0.00807 379.72 $52.80 $20,049.22 $0.01480 24.8 $798.53 $19,803.54 $0.00357 2,280.85 -0.00726484 19,890.94 0.000303245 $101,158.30 0.0010318
2-6-17 157.95 $130.98 $20,688.29 $0.00107 1150.75 $17.61 $20,264.71 -$0.00956 319.44 $63.68 $20,341.94 -$0.00063 379.72 $52.36 $19,882.14 -$0.00833 24.8 $801.49 $19,876.95 $0.00371 2,297.42 0.00211542 19,884.91 -0.0092942915 $101,054.03 -0.0067759
2-7-17 157.95 $132.06 $20,858.88 $0.00825 1150.75 $17.93 $20,632.95 $0.01817 319.44 $63.64 $20,329.16 -$0.00330 379.72 $52.80 $20,049.22 $0.00840 24.8 $801.34 $19,873.23 -$0.00019 2,292.56 -0.00022682 20,071.46 0.0009495113 $101,743.43 -0.0041241
2-8-17 157.95 $131.84 $20,824.13 -$0.00167 1150.75 $18.26 $21,012.70 $0.01840 319.44 $63.43 $20,262.08 -$0.00142 379.72 $52.81 $20,053.01 $0.00019 24.8 $806.97 $20,012.86 $0.00703 2,293.08 -0.00069339 20,052.42 -0.0018849902 $102,164.77 -0.0127042
2-9-17 157.95 134.2 $21,196.89 $0.01790 1150.75 18.72 $21,542.04 $0.02519 319.44 63.34 $20,233.33 $0.01137 379.72 $53.88 $20,459.31 $0.02026 24.8 808.38 $20,047.82 $0.00175 2,294.67 -0.00575246 20,090.29 0.0017926294 $103,479.40 0.0183582
2-10-17 157.95 134.14 $21,187.41 -$0.00045 1150.75 16.41 $18,883.81 -$0.12340 319.44 64.06 $20,463.33 -$0.00094 379.72 55.31 $21,002.31 $0.02654 24.8 809.56 $20,077.09 $0.00146 2,307.87 -0.00356606 20,054.34 -0.005852551 $101,613.95 0.0051330
2-13-17 157.95 134.19 $21,195.31 $0.00037 1150.75 15.58 $17,928.69 -$0.05058 319.44 64 $20,444.16 $0.00516 379.72 56.22 $21,347.86 $0.01645 24.8 813.67 $20,179.02 $0.00508 2,316.10 -0.00524589 20,172.40 -0.0047840658 $101,095.03 -0.0043016
2-14-17 157.95 134.05 $21,173.20 -$0.00104 1150.75 15.81 $18,193.36 $0.01476 319.44 64.33 $20,549.58 $0.00171 379.72 56.09 $21,298.49 -$0.00231 24.8 819.24 $20,317.15 $0.00685 2,328.25 -0.00266294 20,269.37 -0.00699534 $101,531.78 -0.0082448
2-15-17 157.95 133.87 $21,144.77 -$0.00134 1150.75 16.43 $18,906.82 $0.03922 319.44 64.44 $20,584.71 $0.00140 379.72 56.43 $21,427.60 $0.00606 24.8 819.03 $20,311.94 -$0.00026 2,334.45 -0.00633982 20,412.16 -0.0065306035 $102,375.85 -0.0038538
2-16-17 157.95 133.44 $21,076.85 -$0.00321 1150.75 16.74 $19,263.56 $0.01887 319.44 64.53 $20,613.46 -$0.00015 379.72 56.64 $21,507.34 $0.00372 24.8 818.98 $20,310.70 -$0.00006 2,349.25 0.00086411 20,546.34 -0.0031787524 $102,771.91 0.0038411
2-17-17 157.95 133.84 $21,140.03 $0.00300 1150.75 16.35 $18,814.76 -$0.02330 319.44 64.52 $20,610.27 $0.00155 379.72 56.29 $21,374.44 -$0.00618 24.8 824.16 $20,439.17 $0.00632 2,347.22 0.00000000 20,611.86 -0.0003836124 $102,378.67 -0.0007803
2-20-17 157.95 133.53 $21,091.06 -$0.00232 1150.75 16.35 $18,814.76 $0.00000 319.44 64.62 $20,642.21 $0.00000 379.72 56.29 $21,374.44 $0.00000 24.8 828.07 $20,536.14 $0.00474 2,347.22 -0.00167858 20,619.77 0 $102,458.61 -0.0047149
2-21-17 157.95 133.53 $21,091.06 $0.00000 1150.75 16.62 $19,125.47 $0.01651 319.44 64.62 $20,642.21 -$0.00201 379.72 56.75 $21,549.11 $0.00817 24.8 828.07 $20,536.14 $0.00000 2,351.16 -0.00604808 20,619.77 -0.0002075247 $102,943.99 -0.0007668
2-22-17 157.95 133.72 $21,121.07 $0.00142 1150.75 16.42 $18,895.32 -$0.01203 319.44 64.49 $20,600.69 -$0.00202 379.72 57.36 $21,780.74 $0.01075 24.8 831.66 $20,625.17 $0.00434 2,365.38 0.00108228 20,624.05 -0.0057344646 $103,022.98 -0.0024688
2-23-17 157.95 136.1 $21,497.00 $0.01780 1150.75 16.08 $18,504.06 -$0.02071 319.44 64.36 $20,559.16 $0.00404 379.72 58.24 $22,114.89 $0.01534 24.8 830.76 $20,602.85 -$0.00108 2,362.82 -0.00041899 20,743.00 -0.0015691484 $103,277.95 0.0038880
2-24-17 157.95 135.36 $21,380.11 -$0.00544 1150.75 16.03 $18,446.52 -$0.00311 319.44 64.62 $20,642.21 $0.00000 379.72 57.39 $21,792.13 -$0.01459 24.8 831.33 $20,616.98 $0.00069 2,363.81 -0.00149335 20,775.60 -0.001668403 $102,877.96 -0.0006494
2-27-17 157.95 135.44 $21,392.75 $0.00059 1150.75 15.98 $18,388.99 -$0.00312 319.44 64.62 $20,642.21 -$0.00604 379.72 57.86 $21,970.60 $0.00819 24.8 828.64 $20,550.27 -$0.00324 2,367.34 -0.00101802 20,810.32 -0.0005494252 $102,944.82 -0.0016925
2-28-17 157.95 136.41 $21,545.96 $0.00716 1150.75 16.06 $18,481.05 $0.00501 319.44 64.23 $20,517.63 -$0.00389 379.72 57.96 $22,008.57 $0.00173 24.8 829.28 $20,566.14 $0.00077 2,369.75 0.00257833 20,821.76 -0.0007524917 $103,119.35 0.0098449
3-1-17 157.95 135.54 $21,408.54 -$0.00638 1150.75 15.77 $18,147.33 -$0.01806 319.44 63.98 $20,437.77 $0.00031 379.72 57.16 $21,704.80 -$0.01380 24.8 823.21 $20,415.61 -$0.00732 2,363.64 -0.00473422 20,837.44 0.0012108259 $102,114.04 -0.0031294
3-2-17 157.95 135.78 $21,446.45 $0.00177 1150.75 15.79 $18,170.34 $0.00127 319.44 64 $20,444.16 $0.00016 379.72 57.55 $21,852.89 $0.00682 24.8 827.45 $20,520.76 $0.00515 2,374.83 -0.00298548 20,812.24 -0.0058534171 $102,434.60 -0.0031635
3-3-17 157.95 136.76 $21,601.24 $0.00722 1150.75 15.79 $18,170.34 $0.00000 319.44 64.01 $20,447.35 $0.00406 379.72 57.8 $21,947.82 $0.00434 24.8 830.36 $20,592.93 $0.00352 2,381.92 0.01727178 20,934.78 -0.0032466837 $102,759.68 0.0021233
3-6-17 157.95 136.98 $21,635.99 $0.00161 1150.75 15.45 $17,779.09 -$0.02153 319.44 64.27 $20,530.41 $0.00124 379.72 57.79 $21,944.02 -$0.00017 24.8 832.76 $20,652.45 $0.00289 2,340.78 0.00038022 21,002.97 -0.0000176162 $102,541.95 0.0007808
3-7-17 157.95 137.34 $21,692.85 $0.00263 1150.75 15.42 $17,744.57 -$0.00194 319.44 64.35 $20,555.96 $0.00497 379.72 57.35 $21,776.94 -$0.00761 24.8 834.34 $20,691.63 $0.00190 2,339.89 -0.00470108 21,003.34 0.0032720575 $102,461.96 -0.0005680
3-8-17 157.95 137.57 $21,729.18 $0.00167 1150.75 15.39 $17,710.04 -$0.00195 319.44 64.67 $20,658.18 $0.00031 379.72 57.2 $21,719.98 -$0.00262 24.8 834.79 $20,702.79 $0.00054 2,350.89 -0.00427498 20,934.84 0.0010701754 $102,520.18 0.0019315
3-9-17 157.95 138.1 $21,812.90 $0.00385 1150.75 15.34 $17,652.51 -$0.00325 319.44 64.69 $20,664.57 $0.00062 379.72 56.55 $21,473.17 -$0.01136 24.8 835.46 $20,719.41 $0.00080 2,360.94 -0.00166459 20,912.46 0.0018765609 $102,322.55 0.0009341
3-10-17 157.95 138.24 $21,835.01 $0.00101 1150.75 15.22 $17,514.42 -$0.00782 319.44 64.73 $20,677.35 -$0.00031 379.72 56.36 $21,401.02 -$0.00336 24.8 838.68 $20,799.26 $0.00385 2,364.87 -0.00078651 20,873.29 0.0007239363 $102,227.06 -0.0014651
3-13-17 157.95 138.84 $21,929.78 $0.00434 1150.75 15.22 $17,514.42 $0.00000 319.44 64.71 $20,670.96 $0.00000 379.72 56.47 $21,442.79 $0.00195 24.8 839.48 $20,819.10 $0.00095 2,366.73 -0.00284781 20,858.19 -0.0007258062 $102,377.05 -0.0032593
3-14-17 157.95 139.6 $22,049.82 $0.00547 1150.75 15.21 $17,502.91 -$0.00066 319.44 64.71 $20,670.96 -$0.00464 379.72 56.67 $21,518.73 $0.00354 24.8 845.54 $20,969.39 $0.00722 2,373.47 0.00337902 20,873.34 -0.0003898191 $102,711.81 -0.0021387
3-15-17 157.95 139.32 $22,005.59 -$0.00201 1150.75 15.32 $17,629.49 $0.00723 319.44 64.41 $20,575.13 $0.00264 379.72 57.28 $21,750.36 $0.01076 24.8 845.62 $20,971.38 $0.00009 2,365.45 -0.00392737 20,881.48 0.0021168698 $102,931.95 -0.0019505
3-16-17 157.95 139.67 $22,060.88 $0.00251 1150.75 15.26 $17,560.45 -$0.00392 319.44 64.58 $20,629.44 $0.00093 379.72 57.59 $21,868.07 $0.00541 24.8 847.35 $21,014.28 $0.00205 2,374.74 -0.00279610 20,837.37 -0.0022246877 $103,133.11 -0.0002755
3-17-17 157.95 139.99 $22,111.42 $0.00229 1150.75 15.19 $17,479.89 -$0.00459 319.44 64.64 $20,648.60 $0.00356 379.72 57.6 $21,871.87 $0.00017 24.8 848.78 $21,049.74 $0.00169 2,381.38 0.00131436 20,883.83 -0.0024227891 $103,161.53 -0.0008084
3-20-17 157.95 139.84 $22,087.73 -$0.00107 1150.75 15.08 $17,353.31 -$0.00724 319.44 64.87 $20,722.07 $0.00092 379.72 57.8 $21,947.82 $0.00347 24.8 852.18 $21,134.06 $0.00401 2,378.25 0.00200988 20,934.55 0.0009529219 $103,244.99 -0.0027709
3-21-17 157.95 139.94 $22,103.52 $0.00072 1150.75 15.09 $17,364.82 $0.00066 319.44 64.93 $20,741.24 -$0.01109 379.72 58.68 $22,281.97 $0.01522 24.8 848.4 $21,040.32 -$0.00444 2,373.47 0.01240799 20,914.62 0.0004190213 $103,531.87 0.0175746
3-22-17 157.95 138.51 $21,877.65 -$0.01022 1150.75 14.54 $16,731.91 -$0.03645 319.44 64.21 $20,511.24 $0.01277 379.72 58.01 $22,027.56 -$0.01142 24.8 830.46 $20,595.41 -$0.02115 2,344.02 -0.00188992 20,905.86 0.0115081229 $101,743.77 0.0061001
3-23-17 157.95 139.95 $22,105.10 $0.01040 1150.75 14.98 $17,238.24 $0.03026 319.44 65.03 $20,773.18 -$0.00246 379.72 53.82 $20,436.53 -$0.07223 24.8 829.59 $20,573.83 -$0.00105 2,348.45 0.00106027 20,668.01 0.0003247618 $101,126.88 -0.0011431
3-24-17 157.95 139.53 $22,038.76 -$0.00300 1150.75 14.93 $17,180.70 -$0.00334 319.44 64.87 $20,722.07 $0.00170 379.72 55.37 $21,025.10 $0.02880 24.8 817.58 $20,275.98 -$0.01448 2,345.96 0.00000000 20,661.30 0.0002284986 $101,242.61 -0.0068913
3-27-17 157.95 140.34 $22,166.70 $0.00581 1150.75 15.14 $17,422.36 $0.01407 319.44 64.98 $20,757.21 $0.00185 379.72 56.36 $21,401.02 $0.01788 24.8 814.43 $20,197.86 -$0.00385 2,345.96 0.00186278 20,656.58 0 $101,945.15 0.0017169
3-28-17 157.95 140.32 $22,163.54 -$0.00014 1150.75 14.99 $17,249.74 -$0.00991 319.44 65.1 $20,795.54 $0.00292 379.72 55.93 $21,237.74 -$0.00763 24.8 819.51 $20,323.85 $0.00624 2,341.59 -0.00725148 20,656.58 0.0051384411 $101,770.42 -0.0051573
3-29-17 157.95 141.76 $22,390.99 $0.01026 1150.75 14.94 $17,192.21 -$0.00334 319.44 65.29 $20,856.24 $0.00276 379.72 56.62 $21,499.75 $0.01234 24.8 820.92 $20,358.82 $0.00172 2,358.57 -0.00108540 20,550.98 -0.0072709707 $102,298.00 -0.0057932
3-30-17 157.95 142.65 $22,531.57 $0.00628 1150.75 15.04 $17,307.28 $0.00669 319.44 65.47 $20,913.74 $0.00367 379.72 56.68 $21,522.53 $0.00106 24.8 831.41 $20,618.97 $0.01278 2,361.13 -0.00293504 20,701.50 0.0020416935 $102,894.08 0.0033165
3-31-17 157.95 142.41 $22,493.66 -$0.00168 1150.75 14.92 $17,169.19 -$0.00798 319.44 65.71 $20,990.40 $0.00228 379.72 56.04 $21,279.51 -$0.01129 24.8 831.5 $20,621.20 $0.00011 2,368.06 0.00225501 20,659.32 -0.0033369531 $102,553.96 0.0013694
4-3-17 157.95 142.05 $22,436.80 -$0.00253 1150.75 14.95 $17,203.71 $0.00201 319.44 65.86 $21,038.32 -$0.00471 379.72 55.73 $21,161.80 -$0.00553 24.8 829.56 $20,573.09 -$0.00233 2,362.72 0.00164218 20,728.49 0.0031587526 $102,413.71 -0.0000322
4-4-17 157.95 142.28 $22,473.13 $0.00162 1150.75 14.84 $17,077.13 -$0.00736 319.44 65.55 $20,939.29 $0.00275 379.72 55.65 $21,131.42 -$0.00144 24.8 838.55 $20,796.04 $0.01084 2,358.84 -0.00055960 20,663.22 0.0006300178 $102,417.01 0.0052247
4-5-17 157.95 141.73 $22,386.25 -$0.00387 1150.75 14.69 $16,904.52 -$0.01011 319.44 65.73 $20,996.79 -$0.00259 379.72 55.04 $20,899.79 -$0.01096 24.8 834.57 $20,697.34 -$0.00475 2,360.16 0.00305488 20,650.21 -0.0018864879 $101,884.69 0.0031568
4/6/17 157.95 141.85 $22,405.21 $0.00085 1150.75 14.53 $16,720.40 -$0.01089 319.44 65.56 $20,942.49 $0.00259 379.72 54.98 $20,877.01 -$0.00109 24.8 831.41 $20,618.97 -$0.00379 2,352.95 -0.00192949 20,689.24 0.0019900088 $101,564.07 0.0023785
4/7/17 157.95 141.17 $22,297.80 -$0.00479 1150.75 14.39 $16,559.29 -$0.00964 319.44 65.73 $20,996.79 -$0.00076 379.72 55.14 $20,937.76 $0.00291 24.8 827.88 $20,531.42 -$0.00425 2,357.49 0.00082715 20,648.15 -0.0007162578 $101,323.07 0.0028073
4/10/17 157.95 140.78 $22,236.20 -$0.00276 1150.75 14.29 $16,444.22 -$0.00695 319.44 65.68 $20,980.82 -$0.00228 379.72 55.11 $20,926.37 -$0.00054 24.8 824.67 $20,451.82 -$0.00388 2,355.54 -0.00068774 20,662.95 0.0003316212 $101,039.42 0.0000450
4/11/17 157.95 141.04 $22,277.27 $0.00185 1150.75 14.36 $16,524.77 $0.00490 319.44 65.53 $20,932.90 -$0.00076 379.72 54.9 $20,846.63 -$0.00381 24.8 824.73 $20,453.30 $0.00007 2,357.16 0.00143393 20,656.10 -0.0000929421 $101,034.87 0.0027496
4/12/17 157.95 139.92 $22,100.36 -$0.00794 1150.75 14.31 $16,467.23 -$0.00348 319.44 65.48 $20,916.93 -$0.00382 379.72 54.92 $20,854.22 $0.00036 24.8 823.35 $20,419.08 -$0.00167 2,353.78 0.00375991 20,658.02 0.0003254032 $100,757.83 -0.0026122
4/13/17 157.95 139.58 $22,046.66 -$0.00243 1150.75 14.42 $16,593.82 $0.00769 319.44 65.23 $20,837.07 $0.00092 379.72 55.57 $21,101.04 $0.01184 24.8 824.32 $20,443.14 $0.00118 2,344.93 0.00125803 20,651.30 0.0028865775 $101,021.72 0.0000869
4/14/17 157.95 139.62 $22,052.98 $0.00029 1150.75 14.49 $16,674.37 $0.00485 319.44 65.29 $20,856.24 -$0.00521 379.72 55.41 $21,040.29 -$0.00288 24.8 822.14 $20,389.07 -$0.00264 2,341.98 0.00556367 20,591.86 0.0014672918 $101,012.94 0.0035262
4/17/17 157.95 139.39 $22,016.65 -$0.00165 1150.75 14.3 $16,455.73 -$0.01311 319.44 64.95 $20,747.63 $0.00816 379.72 55.34 $21,013.70 -$0.00126 24.8 823.56 $20,424.29 $0.00173 2,328.95 -0.00861332 20,561.69 0.0053018469 $100,658.00 -0.0125982
4/18/17 157.95 141.42 $22,337.29 $0.01456 1150.75 14.4 $16,570.80 $0.00699 319.44 65.48 $20,916.93 -$0.00137 379.72 56.24 $21,355.45 $0.01626 24.8 837.17 $20,761.82 $0.01653 2,349.01 0.00290335 20,453.25 -0.0089000684 $101,942.29 0.0011138
4/19/17 157.95 140.96 $22,264.63 -$0.00325 1150.75 14.44 $16,616.83 $0.00278 319.44 65.39 $20,888.18 -$0.00535 379.72 56.11 $21,306.09 -$0.00231 24.8 836.82 $20,753.14 -$0.00042 2,342.19 0.00171634 20,636.92 0.0055371266 $101,828.87 -0.0014682
4/20/17 157.95 142.27 $22,471.55 $0.00929 1150.75 14.54 $16,731.91 $0.00693 319.44 65.04 $20,776.38 $0.00707 379.72 55.86 $21,211.16 -$0.00446 24.8 838.21 $20,787.61 $0.00166 2,338.17 -0.00755719 20,523.28 0.0058217579 $101,978.60 -0.0078373
4/21/17 157.95 143.8 $22,713.21 $0.01075 1150.75 14.65 $16,858.49 $0.00757 319.44 65.5 $20,923.32 $0.01374 379.72 56.4 $21,416.21 $0.00967 24.8 841.65 $20,872.92 $0.00410 2,355.84 0.00303501 20,404.49 -0.0084660312 $102,784.15 -0.0007279
4/24/17 157.95 143.68 $22,694.26 -$0.00083 1150.75 14.63 $16,835.47 -$0.00137 319.44 66.4 $21,210.82 $0.01702 379.72 55.85 $21,207.36 -$0.00975 24.8 843.19 $20,911.11 $0.00183 2,348.69 -0.01084009 20,578.71 0.0015062469 $102,859.02 -0.0103602
4/25/17 157.95 145.47 $22,976.99 $0.01246 1150.75 14.71 $16,927.53 $0.00547 319.44 67.53 $21,571.78 $0.00444 379.72 55.47 $21,063.07 -$0.00680 24.8 862.76 $21,396.45 $0.02321 2,374.15 -0.00609060 20,547.76 -0.0104089359 $103,935.82 -0.0156278
4/26/17 157.95 146.56 $23,149.15 $0.00749 1150.75 15.82 $18,204.87 $0.07546 319.44 67.83 $21,667.62 $0.00501 379.72 55.16 $20,945.36 -$0.00559 24.8 871.73 $21,618.90 $0.01040 2,388.61 0.00048564 20,763.89 -0.011060615 $105,585.89 -0.0119303
4/27/17 157.95 147.65 $23,321.32 $0.00744 1150.75 16.54 $19,033.41 $0.04551 319.44 68.17 $21,776.22 $0.00147 379.72 55.5 $21,074.46 $0.00616 24.8 873.2 $21,655.36 $0.00169 2,387.45 -0.00055289 20,996.12 0.0010026179 $106,860.77 -0.0008011
4/28/17 157.95 147.7 $23,329.22 $0.00034 1150.75 16.61 $19,113.96 $0.00423 319.44 68.27 $21,808.17 -$1.00000 379.72 55.34 $21,013.70 -$0.00288 24.8 874.25 $21,681.40 $0.00120 2,388.77 1.00000000 20,975.09 -0.0002974073 $106,946.45 ERROR:#DIV/0!
20,981.33 ERROR:#DIV/0! $0.00
Facebook Summary Statistics Twitter Summary Statistics Microsoft Summary Statistics Nike Summary Statistics Google Summary Statistics S&P 500 Summary Statistics DOW Jones Summary Statistics Portfolio Summary Statistics
Mean 136.8222368421 Mean 15.8088157895 Mean 64.6657894737 Mean 55.5082894737 Mean 827.0569736842 Mean 2336.882631579 Mean 20510.4580263158 Mean 102048.527494737
Standard Error 0.5970952376 Standard Error 0.1261259419 Standard Error 0.1386339701 Standard Error 0.1994380164 Standard Error 1.9599168441 Standard Error 4.2003664058 Standard Error 43.9038573308 Standard Error 157.3438573576
Median 137.455 Median 15.675 Median 64.63 Median 55.79 Median 828.07 Median 2348.57 Median 20649.18 Median 102046.3206
Mode 130.98 Mode 16.61 Mode 64.62 Mode 53.65 Mode 828.07 Mode 2271.89 Mode 19804.72 Mode ERROR:#N/A
Standard Deviation 5.2053556007 Standard Deviation 1.0995404702 Standard Deviation 1.2085829313 Standard Deviation 1.7386603181 Standard Deviation 17.0861589223 Standard Deviation 36.6179453772 Standard Deviation 382.7449546735 Standard Deviation 1371.6919472174
Sample Variance 27.0957269298 Sample Variance 1.2089892456 Sample Variance 1.4606727018 Sample Variance 3.0229397018 Sample Variance 291.9368267193 Sample Variance 1340.8739236491 Sample Variance 146493.700328053 Sample Variance 1881538.798061
Kurtosis -0.6820579897 Kurtosis -0.612454759 Kurtosis 1.4431677456 Kurtosis -0.9737609098 Kurtosis 0.651802618 Kurtosis -0.8162643706 Kurtosis -0.8889293124 Kurtosis 3.1194464158
Skewness -0.1373228505 Skewness 0.4891611802 Skewness 0.6026270759 Skewness -0.3170466698 Skewness 0.5061753537 Skewness -0.7044641119 Skewness -0.6797851311 Skewness 1.0229663619
Range 21.08 Range 4.43 Range 5.97 Range 6.65 Range 78.56 Range 125.08 Range 1270.94 Range 7593.7775
Minimum 126.62 Minimum 14.29 Minimum 62.3 Minimum 52.03 Minimum 795.69 Minimum 2263.69 Minimum 19732.4 Minimum 99352.6686
Maximum 147.7 Maximum 18.72 Maximum 68.27 Maximum 58.68 Maximum 874.25 Maximum 2388.77 Maximum 21003.34 Maximum 106946.4461
Sum 10398.49 Sum 1201.47 Sum 4914.6 Sum 4218.63 Sum 62856.33 Sum 177603.08 Sum 1558794.81 Sum 7755688.0896
Count 76 Count 76 Count 76 Count 76 Count 76 Count 76 Count 76 Count 76
Calculated Beta -0.0266387315 Calculated Beta 0.1495631506 Calculated Beta -0.5303650022 Calculated Beta 0.0292520735 Calculated Beta -0.3303543321
Published Beta 0.47 Published Beta 1.07 Published Beta 1.38 Published Beta 0.43 Published Beta 0.94
Profolio Beta -0.1515281
CorrelationS&P500 0.3741760534
Correlation S&P 500 -0.3201598015 Correlation S&P 500 -0.0901654269 Correlation S&P500 -0.0023447365 Correlation S&P 500 -0.1272300872 Correlation S&P 500 -0.4114924421
Correlation DOW -0.332686841 Correlation DOW -0.0380354694 Correlation DOW -0.0144781026 Correlation DOW -0.1815893742 Correlation DOW -0.4507433038 Correlation DOW 0.3022254775