Date Close 3/1/2015 124.43 4/1/2015 125.150002 0.005769725 1.26142E-05 5/1/2015 130.279999 0.040172939 0.000951819 6/1/2015 125.43 -0.037938139 0.002233461 7/1/2015 121.300003 -0.033480993 0.001832042 8/1/2015 112.919998 -0.071587255 0.006546206 9/1/2015 110.300003 -0.023475632 0.001075643 10/1/2015 119.5 0.080112418 0.005011372 11/1/2015 118.300003 -0.010092575 0.000376901 12/1/2015 105.260002 -0.116790297 0.015904153 1/1/2016 97.339996 -0.078223536 0.007664111 2/1/2016 96.690002 -0.006699958 0.000256683 3/1/2016 108.989998 0.119746111 0.012193623 4/1/2016 93.739998 -0.150731145 0.025616808 5/1/2016 99.860001 0.063244244 0.002907676 6/1/2016 95.599998 -0.043596416 0.002800292 7/1/2016 104.209999 0.086235285 0.00591575 8/1/2016 106.099998 0.017973942 7.4867E-05 9/1/2016 113.050003 0.063448198 0.002929713 10/1/2016 113.540001 0.004324981 2.49639E-05 11/1/2016 110.519997 -0.026958734 0.001316246 12/1/2016 115.82 0.046840789 0.001407707 1/1/2017 121.349998 0.046641654 0.001392803 2/1/2017 136.990005 0.121229051 0.012523329 3/1/2017 143.660004 0.047541458 0.001460775 4/1/2017 143.649994 -6.96808E-05 8.81919E-05 5/1/2017 152.759995 0.061488286 0.002721387 6/1/2017 144.020004 -0.058915823 0.004656315 7/1/2017 148.729996 0.032180348 0.000522533 8/1/2017 164 0.097733873 0.00781677 9/1/2017 154.119995 -0.062134941 0.005106005 10/1/2017 169.039993 0.092403845 0.006902697 11/1/2017 171.850006 0.016486706 5.1342E-05 12/1/2017 169.229996 -0.015363325 0.000609334 1/1/2018 167.429993 -0.010693401 0.000400591 2/1/2018 172.429993 0.029426005 0.000404196 E(X) 0.009321372 0.004048826 0.00416791 0.004048826 Sigma 0.063630389 fce 0.063630389 ##### Sheet/List 2 ##### Date PRICES Appl Amzn Tesl Mics RETURNS VARIANCES 3/1/2015 124.43 372.100006 188.770004 40.66 Std.Dev 4/1/2015 125.150002 421.779999 226.050003 48.639999 0.005769725 0.125321197 0.180226863 0.179201409 1.26142E-05 0.007479727 0.026829293 0.024295952 5/1/2015 130.279999 429.230011 250.800003 46.860001 0.040172939 0.017509083 0.103899594 -0.037281763 0.000951819 0.000454828 0.007650866 0.003673764 6/1/2015 125.43 434.089996 268.26001 44.150002 -0.037938139 0.011258945 0.067300876 -0.059571482 0.002233461 0.000760482 0.002587809 0.006872626 7/1/2015 121.300003 536.150024 266.149994 46.700001 -0.033480993 0.211162141 -0.00789666 0.056151214 0.001832042 0.029696375 0.000591804 0.001077244 8/1/2015 112.919998 512.890015 249.059998 43.52 -0.071587255 -0.044352591 -0.066366214 -0.070523584 0.006546206 0.006920305 0.006855273 0.008808462 9/1/2015 110.300003 511.890015 248.399994 44.259998 -0.023475632 -0.001951639 -0.002653497 0.016860687 0.001075643 0.001663614 0.000364194 4.18497E-05 10/1/2015 119.5 625.900024 206.929993 52.639999 0.080112418 0.201080865 -0.182659788 0.173394979 0.005011372 0.026323468 0.039636889 0.022519551 11/1/2015 118.300003 664.799988 230.259995 54.349998 -0.010092575 0.060295573 0.106828546 0.031968309 0.000376901 0.000460523 0.008171831 7.46235E-05 12/1/2015 105.260002 675.890015 240.009995 55.48 -0.116790297 0.016544138 0.041471485 0.020578019 0.015904153 0.000496917 0.000627058 7.57242E-06 1/1/2016 97.339996 587 191.199997 55.09 -0.078223536 -0.141005543 -0.227360583 -0.007054384 0.007664111 0.032342901 0.059434026 0.0009232 2/1/2016 96.690002 552.52002 191.929993 50.880001 -0.006699958 -0.060535152 0.003810701 -0.079498273 0.000256683 0.009874582 0.000159256 0.010573617 3/1/2016 108.989998 593.640015 229.770004 55.23 0.119746111 0.071783432 0.17994814 0.082036345 0.012193623 0.001085548 0.026738063 0.003446456 4/1/2016 93.739998 659.590027 240.759995 49.869999 -0.150731145 0.105345371 0.04672174 -0.102086684 0.025616808 0.004423526 0.000917567 0.0157293 5/1/2016 99.860001 722.789978 223.229996 53 0.063244244 0.091500222 -0.075597954 0.060872314 0.002907676 0.002773544 0.008469211 0.001409439 6/1/2016 95.599998 715.619995 212.279999 51.169998 -0.043596416 -0.0099694 -0.050296459 -0.03513853 0.002800292 0.002381946 0.004452469 0.003418548 7/1/2016 104.209999 758.809998 234.789993 56.68 0.086235285 0.058602121 0.100785315 0.102268031 0.00591575 0.000390708 0.007115758 0.006231241 8/1/2016 106.099998 769.159973 212.009995 57.459999 0.017973942 0.013547561 -0.102058048 0.013667621 7.4867E-05 0.000639494 0.014039504 9.33581E-05 9/1/2016 113.050003 837.309998 204.029999 57.599998 0.063448198 0.084895395 -0.038366383 0.002433497 0.002929713 0.002121488 0.003002684 0.000436656 10/1/2016 113.540001 789.820007 197.729996 59.919998 0.004324981 -0.05838929 -0.031364593 0.039487773 2.49639E-05 0.009452714 0.002284358 0.000261079 11/1/2016 110.519997 750.570007 189.399994 60.259998 -0.026958734 -0.050972153 -0.043041294 0.005658195 0.001316246 0.008065465 0.003536878 0.000312286 12/1/2016 115.82 768.659973 213.690002 62.139999 0.046840789 0.023815777 0.120665227 0.030721387 0.001407707 0.0002256 0.010864907 5.46352E-05 1/1/2017 121.349998 823.47998 251.929993 64.650002 0.046641654 0.068890534 0.164624867 0.039598248 0.001392803 0.000903288 0.021961611 0.000264662 2/1/2017 136.990005 845.039978 249.990005 63.98 0.121229051 0.025844699 -0.007730306 -0.010417602 0.012523329 0.000168768 0.000583738 0.001138889 3/1/2017 143.660004 886.539978 278.299988 65.860001 0.047541458 0.047942283 0.107278688 0.028960758 0.001460775 8.29284E-05 0.008253418 3.17074E-05 4/1/2017 143.649994 924.98999 314.070007 68.459999 -6.96808E-05 0.042456695 0.120916288 0.038718326 8.81919E-05 1.3111E-05 0.010917308 0.000236806 5/1/2017 152.759995 994.619995 341.01001 69.839996 0.061488286 0.072577834 0.082295918 0.019957236 0.002721387 0.001138526 0.004338271 1.13743E-05 6/1/2017 144.020004 968 361.609985 68.93 -0.058915823 -0.027128662 0.05865441 -0.013115357 0.004656315 0.004351308 0.00178287 0.001328251 7/1/2017 148.729996 987.780029 323.470001 72.699997 0.032180348 0.020227943 -0.111459864 0.053249846 0.000522533 0.000346252 0.016355911 0.000895208 8/1/2017 164 980.599976 355.899994 74.769997 0.097733873 -0.007295426 0.095543399 0.028075352 0.00781677 0.002128088 0.006258872 2.25201E-05 9/1/2017 154.119995 961.349976 341.100006 74.489998 -0.062134941 -0.019826083 -0.042474069 -0.003751834 0.005106005 0.003441214 0.003469732 0.000733416 10/1/2017 169.039993 1105.280029 331.529999 83.18 0.092403845 0.13951548 -0.028457407 0.110342073 0.006902697 0.010136402 0.002014912 0.007571132 11/1/2017 171.850006 1176.75 308.850006 84.169998 0.016486706 0.062657679 -0.070862559 0.011831605 5.1342E-05 0.000567483 0.007620054 0.000132209 12/1/2017 169.229996 1169.469971 311.350006 85.540001 -0.015363325 -0.006205771 0.008061959 0.016145575 0.000609334 0.002028741 7.00302E-05 5.16134E-05 1/1/2018 167.429993 1450.890015 354.309998 95.010002 -0.010693401 0.215626542 0.12925453 0.104998056 0.000400591 0.031254974 0.012729292 0.0066697 2/1/2018 172.429993 1448.689941 335.48999 92 0.029426005 -0.001517513 -0.054580111 -0.032193593 0.000404196 0.001628388 0.005042488 0.00308285 Average E(X) 0.009321372 0.03883578 0.016430364 0.023329822 Var(X) 0.004048826 0.005892092 0.009592234 0.003783766 fce 0.004048826 0.005892092 0.009592234 0.003783766 Sigma Sigma(X) 0.063630389 0.076759965 0.097939953 0.061512321 fce fce 0.063630389 0.076759965 0.097939953 0.061512321 "The ""Best"" stock:" Appl Amzn Tesl Misc Return 0.009321372 0.03883578 0.016430364 0.023329822 Risk 0.063630389 0.076759965 0.097939953 0.061512321 Return/risk 0.146492452 0.505937957 0.16775957 0.379270714 so much return on one unit of risk Risk/return 6.826290295 1.976526938 5.96091179 2.636639117 so much risk on one unit of return Amazon is the best choice for a rational investor.