Theoretical price of stock 1-day returns 2-day returns Stock-i ri ri ri var var var Trading day Company 1 Company 2 Company 3 Company 1 Company 2 Company 3 1 100 200 1000 2 110 210 1050 0.09531018 0.048790164 0.048790164 0.010072302 0.00133902 0.003796222 3 121 205 1080 0.09531018 -0.024097552 0.028170877 0.010072302 0.001317334 0.001680524 0.19062036 0.024692613 0.076961041 0.06062548 0.014541137 0.010758112 4 95 150 1020 -0.241913654 -0.312374685 -0.057158414 0.05610407 0.10534713 0.0019656 -0.146603474 -0.336472237 -0.028987537 0.008281257 0.057877876 4.96069E-06 5 98 210 950 0.031090587 0.336472237 -0.071095922 0.001306191 0.105154078 0.003395696 -0.210823067 0.024097552 -0.128254336 0.024093561 0.014397978 0.010301044 E(ri) -0.005050677 0.012197541 -0.012823324 Variance 0.025851621 0.071052521 0.003612681 E(ri) -0.055602061 -0.095894024 -0.026760277 Variance 0.046500149 0.043408496 0.010532058 sigma 0.160784394 0.266556787 0.06010558 sigma 0.215638932 0.208347056 0.102625817 fce 0.025851621 0.071052521 0.003612681 fce 0.046500149 0.043408496 0.010532058 0.160784394 0.266556787 0.06010558 0.215638932 0.208347056 0.102625817 ##### Sheet/List 2 ##### Year 2014 2015 q-returns Company I. II. III. IV. I. II. III. IV. E(ri) Var sigma function of excel A 1010 1055 1100 1031 988 1065 918 1060 0.043590436 0.041769413 -0.064780975 -0.042601786 0.07504738 -0.148532688 0.143826796 0.006902654 0.001345993 0.001215691 0.005138543 0.00245069 0.004643704 0.024160145 0.018748221 0.009617164 0.098067142 0.009617164 B 2650 3000 3848 3228 3638 4205 3979 4731 0.124052649 0.248941244 -0.175690782 0.11957133 0.144840213 -0.055243762 0.173106065 0.082796708 0.001702053 0.027604007 0.066815783 0.001352373 0.003849397 0.019055171 0.00815578 0.021422427 0.146364023 0.021422427 C 1505 2030 2190 2325 2250 2443 1700 1796 0.299242895 0.075865751 0.059818495 -0.032789823 0.082296576 -0.362598541 0.054933719 0.025252725 0.075070613 0.002561678 0.001194793 0.003368937 0.003254001 0.150428604 0.000880961 0.039459931 0.19864524 0.039459931 D 178 300 325 396 351 370 335 327 0.521998924 0.080042708 0.197589029 -0.120627988 0.052716782 -0.099372474 -0.024170361 0.086882374 0.189326412 4.6781E-05 0.012255963 0.04306055 0.001167288 0.034690868 0.01233271 0.048813429 0.220937613 0.048813429 E 281 372 358 494 460 539 443 468 0.280539185 -0.038360868 0.322002531 -0.071309028 0.158489081 -0.196145801 0.054898526 0.072873375 0.043125089 0.012373057 0.062065336 0.020788565 0.007330049 0.072371317 0.000323095 0.036396085 0.190777579 0.036396085 F 2645 3125 3400 3330 3400 3425 3475 4100 0.166763218 0.084341148 -0.020803128 0.020803128 0.00732604 0.014493007 0.165392495 0.062616558 0.010846527 0.000471958 0.006958844 0.001748363 0.003057041 0.002315876 0.010562893 0.005993584 0.077418239 0.005993584 G 547 800 803 1070 975 952 997 944 0.380162925 0.003742986 0.287059214 -0.092976456 -0.023872436 0.046185735 -0.054624604 0.077953909 0.091330289 0.005507261 0.043725028 0.02921719 0.010368605 0.001009217 0.017577062 0.033122442 0.18199572 0.033122442 two-years returns A 0.048318577 B 0.579576957 C 0.176769072 D 0.608176621 E 0.510113627 F 0.438315908 G 0.545677364 ##### Sheet/List 3 ##### Date Close ri var monthly returns 2/19/2019 78.230003 2/20/2019 78.529999 0.003827461 2.34798E-05 2/21/2019 77.82 -0.009082237 6.50298E-05 2/22/2019 78.419998 0.007680504 7.56663E-05 2/25/2019 78.5 0.001019653 4.15258E-06 2/26/2019 78.660004 0.002036193 9.32892E-06 2/27/2019 79.470001 0.010244787 0.000126853 2/28/2019 79.029999 -0.00555209 2.05568E-05 3/1/2019 80 0.01219912 0.000174696 3/4/2019 80.309998 0.003867487 2.38693E-05 3/5/2019 80.190002 -0.001495278 2.27666E-07 3/6/2019 79.279999 -0.011412966 0.000108053 3/7/2019 80.160004 0.01103881 0.00014537 3/8/2019 79.010002 -0.014450235 0.000180421 3/11/2019 79.779999 0.009698382 0.000114844 3/12/2019 80 0.002753801 1.42275E-05 3/13/2019 80.709999 0.008835836 9.71007E-05 3/14/2019 80.440002 -0.003350881 5.44171E-06 3/15/2019 80.150002 -0.003611686 6.72651E-06 3/18/2019 81.080002 0.011536442 0.000157617 3/19/2019 80.870003 -0.002593382 2.48141E-06 0.03318972 0.002800056 3/20/2019 81.32 0.005549025 4.31276E-05 0.034911284 0.002985215 3/21/2019 81.790001 0.00576301 4.59839E-05 0.049756531 0.004827799 3/22/2019 80.480003 -0.016146255 0.00022886 0.025929772 0.002084434 3/25/2019 79.919998 -0.006982634 3.55753E-05 0.017927485 0.001417772 3/26/2019 80.959999 0.012929084 0.000194525 0.028820375 0.002356734 3/27/2019 80.339996 -0.007687614 4.4482E-05 0.010887975 0.000937205 3/28/2019 80.739998 0.004966512 3.5816E-05 0.021406576 0.001691875 3/29/2019 80.800003 0.000742912 3.10128E-06 0.009950368 0.000880677 4/1/2019 81.730003 0.011444166 0.000155309 0.017527047 0.001387777 4/2/2019 81.379997 -0.004291663 1.0716E-05 0.014730662 0.00118725 4/3/2019 80.900002 -0.005915657 2.39857E-05 0.020227971 0.001596306 4/4/2019 82.050003 0.014115005 0.000229012 0.023304167 0.001851581 4/5/2019 82.489998 0.005348196 4.05302E-05 0.043102598 0.003947412 4/8/2019 83 0.006163558 5.15767E-05 0.039567774 0.003515732 4/9/2019 81.93 -0.012975384 0.000142976 0.023838589 0.001897859 4/10/2019 81.559998 -0.004526303 1.23072E-05 0.01047645 0.000912178 4/11/2019 81.949997 0.004770347 3.35065E-05 0.018597679 0.001468692 4/12/2019 80.919998 -0.012648281 0.00013526 0.009561084 0.000857723 4/15/2019 80.650002 -0.003342158 5.40109E-06 -0.005317517 0.0002076 4/16/2019 81.199997 0.006796381 6.10666E-05 0.004072246 0.000566349 4/17/2019 81.43 0.002828545 1.47969E-05 0.001351767 0.000444265 4/18/2019 81.129997 -0.003690986 7.14414E-06 -0.00810223 0.000135108 4/22/2019 82.900002 0.021582317 0.00051078 0.029626343 0.002435637 4/23/2019 83.379997 0.00577335 4.61243E-05 0.042382327 0.003857424 4/24/2019 81.760002 -0.019620286 0.00034604 0.009832958 0.000873722 4/25/2019 82.220001 0.005610443 4.3938E-05 0.023131014 0.001836709 4/26/2019 80.489998 -0.021265665 0.000409963 -0.003101162 0.00027638 4/29/2019 79.970001 -0.006481351 2.98467E-05 -0.010325426 8.83677E-05 4/30/2019 80.279999 0.003868935 2.38834E-05 -0.017900657 3.33127E-06 5/1/2019 78.669998 -0.020258649 0.000370197 -0.033867643 0.000199991 5/2/2019 77.290001 -0.017697269 0.000278194 -0.045649255 0.000672024 5/3/2019 77.470001 0.002326183 1.11845E-05 -0.057438077 0.001422213 5/6/2019 77.129997 -0.004398507 1.14269E-05 -0.067184779 0.002252352 5/7/2019 76.720001 -0.005329827 1.85907E-05 -0.078678164 0.003475377 5/8/2019 76.839996 0.001562842 6.66144E-06 -0.064139938 0.001972613 5/9/2019 76.769997 -0.000911386 1.13952E-08 -0.060525021 0.001664574 5/10/2019 76.559998 -0.002739179 2.96199E-06 -0.068034548 0.002333732 5/13/2019 75.709999 -0.011164482 0.000102948 -0.066550749 0.002192573 5/14/2019 75.809998 0.001319945 5.46661E-06 -0.061888646 0.001777703 5/15/2019 76.370003 0.007359804 7.01899E-05 -0.061325222 0.001730509 5/16/2019 76.360001 -0.000130976 7.87049E-07 -0.064284744 0.001985497 5/17/2019 75.910004 -0.005910531 2.39355E-05 -0.066504289 0.002188224 5/20/2019 75.900002 -0.00013177 7.85642E-07 -0.088218376 0.004691228 5/21/2019 76.25 0.004600705 3.15714E-05 -0.089391021 0.004853238 5/22/2019 75.559998 -0.009090399 6.51615E-05 -0.078861135 0.003496984 5/23/2019 73.790001 -0.023703782 0.000514639 -0.108175359 0.007823319 5/24/2019 74.099998 0.004192271 2.71483E-05 -0.082717423 0.00396794 5/28/2019 72.610001 -0.020312838 0.000372286 -0.09654891 0.005901785 5/29/2019 72.160004 -0.006216736 2.70255E-05 -0.10663458 0.00755313 5/30/2019 71.970001 -0.002636552 2.61928E-06 -0.089012484 0.00480064 5/31/2019 70.769997 -0.01681424 0.000249517 -0.088129454 0.004679055 6/3/2019 71.879997 0.01556288 0.00027493 -0.074892757 0.00304339 6/4/2019 73.589996 0.023511072 0.000601682 -0.046983178 0.000742963 6/5/2019 72.980003 -0.00832362 5.33701E-05 -0.049976971 0.000915131 6/6/2019 74.309998 0.018060033 0.000363976 -0.033479781 0.000189171 6/7/2019 74.580002 0.003626896 2.15763E-05 -0.028941498 8.49285E-05 6/10/2019 74.910004 0.004415045 2.95194E-05 -0.021787275 4.24954E-06 6/11/2019 74.839996 -0.000934998 6.91158E-09 -0.011557791 6.67169E-05 6/12/2019 74.029999 -0.010882045 9.72967E-05 -0.023759781 1.62727E-05 6/13/2019 74.68 0.008741916 9.52586E-05 -0.02237767 7.03224E-06 6/14/2019 74.349998 -0.004428673 1.16318E-05 -0.026675366 4.8296E-05 6/17/2019 75.089996 0.009903695 0.000119286 -0.01086114 7.85828E-05 6/18/2019 75.739998 0.008619055 9.28754E-05 -0.002110315 0.000310306 6/19/2019 75.32 -0.005560692 2.06348E-05 -0.012271712 5.55639E-05 6/20/2019 76.610001 0.016981926 0.000324002 0.013800613 0.001124023 6/21/2019 77.690002 0.013998945 0.000225513 0.05150334 0.005073595 6/24/2019 76.949997 -0.009570753 7.31473E-05 0.037740316 0.003302358 6/25/2019 76.269997 -0.008876184 6.1749E-05 0.04917697 0.004747596 6/26/2019 76.599998 0.004317414 2.84681E-05 0.059711119 0.006310229 6/27/2019 75.82 -0.010234941 8.49495E-05 0.052112731 0.005160779 6/28/2019 76.629997 0.010626496 0.000135597 0.079553466 0.009856379 7/1/2019 76.559998 -0.000913885 1.0868E-08 0.063076701 0.00685626 7/2/2019 75.720001 -0.011032381 0.000100285 0.028533247 0.002328939 7/3/2019 76.440002 0.009463806 0.000109871 0.046320673 0.004362141 7/5/2019 76.129997 -0.00406378 9.27596E-06 0.024196861 0.001929203 7/8/2019 76.480003 0.004586942 3.14169E-05 0.025156906 0.00201446 7/9/2019 76.43 -0.000654019 1.3258E-07 0.020087843 0.001585129 7/10/2019 77.510002 0.014031697 0.000226497 0.035054538 0.003000889 7/11/2019 77.57 0.000773768 3.21092E-06 0.046710352 0.004413767 7/12/2019 77.629997 0.000773157 3.20873E-06 0.038741593 0.00341844 7/15/2019 77.080002 -0.007110042 3.71113E-05 0.036060223 0.003112084 7/16/2019 75.93 -0.015032006 0.000196389 0.011124522 0.000951744 7/17/2019 75.480003 -0.005944103 2.42652E-05 -0.003438636 0.000265273 7/18/2019 74.839996 -0.008515312 5.62077E-05 -0.006393256 0.000177758 7/19/2019 74.989998 0.002002297 9.123E-06 -0.021372885 2.71278E-06 7/22/2019 75.07 0.001066267 4.34473E-06 -0.034305563 0.000212569 7/23/2019 75.370003 0.003988346 2.50648E-05 -0.020746464 1.04169E-06 7/24/2019 75.360001 -0.000132714 7.83969E-07 -0.012002993 5.96423E-05 7/25/2019 74.93 -0.005722299 2.21292E-05 -0.022042706 5.3679E-06 7/26/2019 74.809998 -0.001602805 3.4184E-07 -0.013410571 3.98825E-05 7/29/2019 75.339996 0.00705961 6.525E-05 -0.016977457 7.55357E-06 7/30/2019 75.349998 0.000132749 1.32453E-06 -0.015930822 1.44021E-05 7/31/2019 74.360001 -0.013225722 0.000149025 -0.018124163 2.56535E-06 8/1/2019 72.459999 -0.025883505 0.000618287 -0.053471474 0.001138768 8/2/2019 71.75 -0.009846817 7.79456E-05 -0.059254511 0.001562516 8/5/2019 70.279999 -0.020700606 0.0003874 -0.084542059 0.004201143 8/6/2019 70.959999 0.009629075 0.000113363 -0.074258965 0.002973863 8/7/2019 70.5 -0.006503614 3.00905E-05 -0.094794276 0.005635271 8/8/2019 72.379997 0.026317267 0.000747224 -0.069250778 0.00245272 8/9/2019 70.839996 -0.02150622 0.000419762 -0.091530155 0.005155861 8/12/2019 69.629997 -0.017228291 0.000262769 -0.101648404 0.006711308 8/13/2019 70.489998 0.012275362 0.000176717 -0.074341036 0.00298282 8/14/2019 67.650002 -0.041123443 0.001608436 -0.109520376 0.00806306 8/15/2019 67.25 -0.005930366 2.413E-05 -0.106935429 0.007605514 8/16/2019 68.300003 0.015492792 0.000272611 -0.093444934 0.005434506 8/19/2019 69.449997 0.016697216 0.000313834 -0.077813986 0.003374233 8/20/2019 69.029999 -0.006065848 2.54794E-05 -0.087868179 0.004643379 8/21/2019 69.720001 0.009946057 0.000120213 -0.077789409 0.003371379 8/22/2019 69.57 -0.002153795 1.28973E-06 -0.074220904 0.002969713 8/23/2019 67.489998 -0.030354031 0.000860595 -0.10297213 0.006929946 8/26/2019 67.849998 0.005319948 4.01713E-05 -0.104711792 0.007222613 8/27/2019 67.190002 -0.0097749 7.66809E-05 -0.114619442 0.009004797 8/28/2019 67.68 0.007266259 6.86312E-05 -0.094127461 0.005535602 8/29/2019 68.43 0.01102061 0.000144931 -0.057223347 0.001406064 8/30/2019 68.480003 0.000730451 3.05755E-06 -0.046646079 0.0007247 9/3/2019 68.559998 0.001167469 4.77686E-06 -0.024778004 2.55244E-05 9/4/2019 69.290001 0.010591365 0.00013478 -0.023815714 1.67271E-05 9/5/2019 70.269997 0.014044312 0.000226877 -0.003267787 0.000270867 9/6/2019 70.93 0.009348553 0.000107468 -0.020236501 2.60782E-07 9/9/2019 71.489998 0.007864077 7.88937E-05 0.009133795 0.000832878 9/10/2019 72.07 0.008080317 8.27818E-05 0.034442403 0.002934198 9/11/2019 71.93 -0.001944445 8.58052E-07 0.020222596 0.001595877 9/12/2019 71.980003 0.00069492 2.93456E-06 0.06204096 0.006685808 9/13/2019 72.639999 0.009127376 0.000102931 0.077098702 0.009374991 9/16/2019 73.730003 0.014894092 0.000253199 0.076500002 0.009259411 9/17/2019 73.169998 -0.007624339 4.36419E-05 0.052178448 0.005170226 9/18/2019 72.82 -0.004794831 1.42634E-05 0.053449465 0.005354624 9/19/2019 72.330002 -0.006751634 3.2873E-05 0.036751774 0.00318972 9/20/2019 72.080002 -0.003462367 5.97428E-06 0.035443201 0.003043622 9/23/2019 72.129997 0.000693364 2.92923E-06 0.066490596 0.007433273 9/24/2019 71.139999 -0.013820252 0.000163894 0.047350396 0.00449922 9/25/2019 71.349998 0.002947563 1.57268E-05 0.060072859 0.006367831 9/26/2019 70.970001 -0.005340049 1.86789E-05 0.047466551 0.004514817 9/27/2019 71.480003 0.007160466 6.68895E-05 0.043606407 0.004010973 9/30/2019 70.610001 -0.012245941 0.000126064 0.030630016 0.002535712 10/1/2019 68.949997 -0.023790231 0.000518568 0.005672316 0.000645066 10/2/2019 67.150002 -0.026452608 0.000646912 -0.031371657 0.000135625 10/3/2019 67.980003 0.012284636 0.000176964 -0.033131334 0.000179707 10/4/2019 68.970001 0.014458054 0.000239512 -0.028021833 6.88236E-05 10/7/2019 68.019997 -0.013869906 0.000165168 -0.049755816 0.0009018 10/8/2019 66.699997 -0.019596828 0.000345168 -0.077432961 0.003330113 10/9/2019 67.440002 0.011033435 0.00014524 -0.064455081 0.002000706 10/10/2019 68.25 0.011939091 0.00016789 -0.05321091 0.00112125 10/11/2019 68.980003 0.010639217 0.000135894 -0.05169907 0.001022288 10/14/2019 69.18 0.002895153 1.53138E-05 -0.063698009 0.001933552 10/15/2019 69.419998 0.003463178 2.00822E-05 -0.052610492 0.001081401 10/16/2019 68.230003 -0.017290587 0.000264793 -0.065106248 0.002059382 10/17/2019 68.139999 -0.001319997 9.11212E-08 -0.059674611 0.001595905 10/18/2019 67.610001 -0.007808482 4.61088E-05 -0.064020725 0.001962037 10/21/2019 68.739998 0.016575326 0.00030953 -0.048138763 0.000807295 10/22/2019 69.089996 0.005078702 3.71714E-05 -0.029239808 9.05157E-05 10/23/2019 69.75 0.009507476 0.000110788 -0.022679895 8.72648E-06 10/24/2019 69.089996 -0.009507476 7.20689E-05 -0.026847322 5.07156E-05 10/25/2019 69.25 0.0023132 1.10978E-05 -0.031694587 0.000143251 10/28/2019 68.639999 -0.008847704 6.13022E-05 -0.028296351 7.34538E-05 10/29/2019 68.440002 -0.002917962 3.60935E-06 -0.007424082 0.000151333 10/30/2019 67.720001 -0.010575906 9.1351E-05 0.008452619 0.000794025 10/31/2019 67.57 -0.002217474 1.43842E-06 -0.006049491 0.000187042 11/1/2019 69.599998 0.029600441 0.000937497 0.009092897 0.000830519 11/4/2019 71.669998 0.029307683 0.000919655 0.052270487 0.00518347 11/5/2019 73.089996 0.019619282 0.000425903 0.091486596 0.012368204 11/6/2019 71.489998 -0.022133952 0.000445878 0.058319208 0.006091028 11/7/2019 73.010002 0.021038894 0.000486512 0.067419011 0.007594224 11/8/2019 70.769997 -0.031161306 0.000908611 0.025618489 0.002056108 11/11/2019 70.339996 -0.00609457 2.57702E-05 0.016628767 0.001321657 11/12/2019 69.370003 -0.01388603 0.000165583 -0.000720441 0.000361205 11/13/2019 68.800003 -0.008250752 5.23108E-05 0.008319394 0.000786535 11/14/2019 68.5 -0.004370043 1.12353E-05 0.005269348 0.000624759 11/15/2019 69.190002 0.010022627 0.000121898 0.023100457 0.001834091 11/18/2019 68.519997 -0.009730743 7.59095E-05 -0.003205613 0.000272918 11/19/2019 67.82 -0.010268493 8.55691E-05 -0.018552808 1.37599E-06 11/20/2019 68.029999 0.003091633 1.68902E-05 -0.024968651 2.74871E-05 11/21/2019 69.669998 0.023821011 0.000616983 0.008359836 0.000788805 11/22/2019 69.370003 -0.00431524 1.08709E-05 0.001731396 0.000460413 11/25/2019 68.910004 -0.006653177 3.17537E-05 0.003925923 0.000559406 11/26/2019 68.739998 -0.002470121 2.10827E-06 0.004373764 0.000580791 11/27/2019 68.699997 -0.000582087 1.90137E-07 0.014367584 0.001162361 11/29/2019 68.129997 -0.008331555 5.34861E-05 0.008253503 0.000782843 12/2/2019 68.419998 0.00424755 2.77274E-05 -0.017099388 6.89821E-06 12/3/2019 67.879997 -0.007923754 4.76876E-05 -0.054330826 0.001197506 12/4/2019 68.650002 0.011279765 0.000151238 -0.062670342 0.001844231 12/5/2019 68.410004 -0.00350209 6.17004E-06 -0.044038481 0.000591105 12/6/2019 69.510002 0.015951585 0.000287971 -0.04912579 0.000864357 12/9/2019 69.660004 0.002155666 1.0073E-05 -0.015808817 1.5343E-05 12/10/2019 69.059998 -0.008650659 5.82554E-05 -0.018364907 1.85212E-06 12/11/2019 68.959999 -0.001449051 1.85689E-07 -0.005927929 0.000190382 12/12/2019 70.339996 0.019813958 0.000433976 0.022136782 0.001752478 12/13/2019 69.230003 -0.015906232 0.000221655 0.010600593 0.000919692 12/16/2019 70 0.011060904 0.000145903 0.01163887 0.000983745 12/17/2019 69.68 -0.00458191 1.27005E-05 0.016787703 0.001333238 12/18/2019 69.870003 0.002723083 1.39967E-05 0.029779279 0.002450756 12/19/2019 69.389999 -0.006893665 3.45219E-05 0.019793981 0.001561816 12/20/2019 69.940002 0.00789501 7.94441E-05 0.00386798 0.000556668 12/23/2019 70.290001 0.004991795 3.61193E-05 0.013175015 0.001082466 12/24/2019 70.019997 -0.003848683 8.012E-06 0.015979509 0.001274871 12/26/2019 70.129997 0.001569747 6.69713E-06 0.020019377 0.001579682 12/27/2019 69.889999 -0.003428057 5.80773E-06 0.017173408 0.001361554 12/30/2019 69.480003 -0.005883579 2.36725E-05 0.019621384 0.001548203 12/31/2019 69.779999 0.004308437 2.83724E-05 0.019682271 0.001552999 1/2/2020 70.900002 0.01592304 0.000287003 0.043529066 0.004001182 1/3/2020 70.330002 -0.008071983 4.97568E-05 0.024177317 0.001927487 1/6/2020 70.870003 0.007648776 7.51153E-05 0.035328184 0.003030945 1/7/2020 70.290001 -0.0082177 5.18337E-05 0.0111589 0.000953867 1/8/2020 69.230003 -0.015195217 0.00020099 -0.006191984 0.000183165 1/9/2020 69.760002 0.00762647 7.47292E-05 0.010085145 0.000888694 1/10/2020 69.139999 -0.008927388 6.25563E-05 0.002606808 0.000498747 1/13/2020 69.800003 0.009500633 0.000110644 -0.007706517 0.000144464 1/14/2020 69.199997 -0.008633233 5.79897E-05 -0.000433519 0.000372193 1/15/2020 69.089996 -0.001590875 3.28032E-07 -0.013085297 4.40967E-05 1/16/2020 68.82 -0.003915544 8.39498E-06 -0.012418932 5.33908E-05 1/17/2020 68.559998 -0.003785155 7.6564E-06 -0.01892717 6.37862E-07 1/21/2020 67.580002 -0.014397134 0.000178998 -0.02643064 4.49544E-05 1/22/2020 67.190002 -0.005787654 2.27483E-05 -0.040113304 0.000415649 1/23/2020 66.769997 -0.006270624 2.75886E-05 -0.051375722 0.001001716 1/24/2020 66.32 -0.006762322 3.29957E-05 -0.054289362 0.001194638 1/27/2020 64.739998 -0.024112293 0.00053334 -0.079971402 0.003629529 1/28/2020 64.650002 -0.001391081 1.3909E-07 -0.077934427 0.00338824 1/29/2020 64.110001 -0.008387763 5.43114E-05 -0.080438611 0.003686041 1/30/2020 64.790001 0.010550912 0.000133843 -0.074196136 0.002967014 1/31/2020 62.119999 -0.042083304 0.001686348 -0.13220248 0.012650996 2/3/2020 60.73 -0.022630172 0.00046708 -0.146760669 0.01613785 2/4/2020 59.970001 -0.012593356 0.000133986 -0.167002801 0.021690505 2/5/2020 62.73 0.044995348 0.002117241 -0.113789753 0.008848021 2/6/2020 61.880001 -0.01364276 0.000159381 -0.112237296 0.008558371 2/7/2020 61.470001 -0.006647775 3.16929E-05 -0.126511541 0.011403187 2/10/2020 59.959999 -0.024871611 0.000568988 -0.142455763 0.015062636 2/11/2020 60.529999 0.009461437 0.000109821 -0.142494959 0.015072258 2/12/2020 61.27 0.012151233 0.000173432 -0.121710493 0.010400871 2/13/2020 60.93 -0.005564662 2.06709E-05 -0.12568428 0.011227193 2/14/2020 60.650002 -0.004605996 1.28728E-05 -0.126374732 0.011373988 E® -0.001018134 0.000145037 E® -0.019725833 0.002730018 sigma 0.012043126 std (sigma) 0.052249575 # 250 funcion de excel… 0.000145619 0.002741888 0.012067285 0.052363038