Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the sample mean, standard deviation, skewness, minimum, maximum and range of each log-return series. Date Open High Low Close Adj Close Volume Log Returns
Calculate the sample mean, standard deviation, skewness, minimum, maximum and range of each log-return series.
Date Open High Low Close Adj Close Volume Log Returns 1/10/2015 236.003998 334.169006 235.615997 314.165985 314.165985 953279500 1/11/2015 315.005005 495.562012 300.997009 377.321014 377.321014 2177623396 18.31748603 1/12/2015 377.414001 469.102997 349.464996 430.566986 430.566986 2096250000 13.20065911 1/01/2016 430.721008 462.93399 354.914001 368.766998 368.766998 1990880304 -15.49379094 1/02/2016 369.350006 448.04599 367.957001 437.696991 437.696991 1876238692 17.13618667 1/03/2016 437.916992 439.653015 394.035004 416.729004 416.729004 2332852776 -4.90907296 1/04/2016 416.76001 467.964996 415.830994 448.317993 448.317993 1811475204 7.30666464 1/05/2016 448.484009 553.960022 437.389008 531.385986 531.385986 2234432796 16.99858747 1/06/2016 531.106995 777.98999 525.635986 673.336975 673.336975 4749702740 23.67572490 1/07/2016 672.515015 704.968018 611.833984 624.68103 624.68103 3454186204 -7.50047427 1/08/2016 624.60199 626.119019 531.333984 575.471985 575.471985 2686220180 -8.20506199 1/09/2016 575.546021 628.817993 570.810974 609.734985 609.734985 2004401400 5.78338644 1/10/2016 609.929016 720.401978 609.479004 700.971985 700.971985 2115443796 13.94435100 1/11/2016 701.336975 756.237 678.156006 745.690979 745.690979 2635773092 6.18433552 1/12/2016 746.046021 979.396973 746.046021 963.742981 963.742981 3556763800 25.65133647 1/01/2017 963.65802 1191.099976 755.755981 970.403015 970.403015 5143971692 0.68868227 1/02/2017 970.940979 1200.390015 946.690979 1179.969971 1179.969971 4282761200 19.55328042 1/03/2017 1180.040039 1280.310059 903.713013 1071.790039 1071.790039 10872455960 -9.61588055 1/04/2017 1071.709961 1347.910034 1061.089966 1347.890015 1347.890015 9757448112 22.92102336 1/05/2017 1348.300049 2763.709961 1348.300049 2286.409912 2286.409912 34261856864 52.84424455 1/06/2017 2288.330078 2999.909912 2212.959961 2480.840088 2480.840088 44478140928 8.16143846 1/07/2017 2492.600098 2916.139893 1843.030029 2875.340088 2875.340088 32619956992 14.75737108 1/08/2017 2871.300049 4736.049805 2668.590088 4703.390137 4703.390137 63548016640 49.21125957 1/09/2017 4701.759766 4975.040039 2946.620117 4338.709961 4338.709961 55700949056 -8.07064945 1/10/2017 4341.049805 6470.430176 4164.049805 6468.399902 6468.399902 58009357952 39.93517077 1/11/2017 7446.830078 11517.40039 5519.009766 10233.59961 10233.59961 115000000000 45.87476185 1/12/2017 10198.59961 20089 9694.650391 14156.40039 14156.40039 410000000000 32.44904601 1/01/2018 14112.2002 17712.40039 9402.290039 10221.09961 10221.09961 416000000000 -32.57126733 1/02/2018 10237.29981 11958.5 6048.259766 10397.90039 10397.90039 230000000000 1.71497273 1/03/2018 10385 11704.09961 6683.930176 6973.529785 6973.529785 194000000000 -39.94823782 1/04/2018 7003.060059 9745.320313 6526.870117 9240.549805 9240.549805 197000000000 28.14798646 1/05/2018 9251.469727 9964.5 7090.680176 7494.169922 7494.169922 198000000000 -20.94760121 1/06/2018 7500.700195 7754.890137 5826.410156 6404 6404 130000000000 -15.72025794 1/07/2018 6411.680176 8424.269531 6136.419922 7780.439941 7780.439941 141000000000 19.46900891 1/08/2018 7769.040039 7769.040039 5971.049805 7037.580078 7037.580078 132000000000 -10.03485121 1/09/2018 7044.810059 7388.430176 6197.52002 6625.560059 6625.560059 130000000000 -6.03294667 1/10/2018 6619.850098 6965.060059 6236.470215 6317.609863 6317.609863 118000000000 -4.75939551 1/11/2018 6318.140137 6552.160156 3585.060059 4017.268555 4017.268555 158000000000 -45.27387426 1/12/2018 4024.464355 4309.377441 3191.303467 3742.700439 3742.700439 169000000000 -7.07948144 1/01/2019 3746.713379 4109.020996 3400.819824 3457.792725 3457.792725 167000000000 -7.91769486 1/02/2019 3460.547119 4210.641602 3391.023682 3854.7854 3854.7854 199000000000 10.86848928 1/03/2019 3853.75708 4296.806641 3733.749756 4105.404297 4105.404297 298000000000 6.29888895 1/04/2019 4105.362305 5642.044434 4 4096.901367 5350.726563 5350.726563 445000000000 26.49281309 1/05/2019 5350.914551 9008.314453 5347.645996 8574.501953 8574.501953 724000000000 47.15605522 1/06/2019 8573.839844 13796.48926 7564.48877 10817.15527 10817.15527 676000000000 23.23404147 1/07/2019 10796.93066 13129.5293 9163.134766 10085.62793 10085.62793 676000000000 -7.00218916 1/08/2019 10077.44238 12273.82129 9421.629883 9630.664063 9630.664063 534000000000 -4.61592521 1/09/2019 9630.592773 10898.76172 7830.758789 8293.868164 8293.868164 481000000000 -14.94357148 1/10/2019 8299.720703 10021.74414 7446.98877 9199.584961 9199.584961 595000000000 10.36419038 1/11/2019 9193.992188 9505.051758 6617.166992 7569.629883 7569.629883 677000000000 -19.50141965 1/12/2019 7571.616211 7743.431641 6540.049316 7193.599121 7193.599121 634000000000 -5.09525540 1/01/2020 7194.89209 9553.125977 6914.996094 9350.529297 9350.529297 853000000000 26.22413314 1/02/2020 9346.357422 10457.62695 8492.932617 8599.508789 8599.508789 1160000000000 -8.37278669 1/03/2020 8599.758789 9167.695313 4106.980957 6438.644531 6438.644531 1290000000000 -28.93870427 1/04/2020 6437.319336 9440.650391 6202.373535 8658.553711 8658.553711 1160000000000 29.62296592 1/05/2020 8672.782227 9996.743164 8374.323242 9461.058594 9461.058594 1290000000000 8.86365783 1/06/2020 9463.605469 10199.56543 8975.525391 9137.993164 9137.993164 651000000000 -3.47434839 1/07/2020 9145.985352 11415.86426 8977.015625 11323.4668 11323.4668 546000000000 21.44364852 1/08/2020 11322.57031 12359.05664 11012.41504 11680.82031 11680.82031 708000000000 3.10709266 1/09/2020 11679.31641 12067.08106 9916.493164 10784.49121 10784.49121 1080000000000 -7.98391039 1/10/2020 10795.25488 14028.21387 10416.68945 13780.99512 13780.99512 1050000000000 24.51813748 1/11/2020 13780.99512 19749.26367 13243.16016 19625.83594 19625.83594 1090000000000 35.35563806 1/12/2020 19633.76953 29244.87695 17619.5332 29001.7207 29001.7207 1210000000000 39.05083043 1/01/2021 28994.00977 41946.73828 28722.75586 33114.35938 33114.35938 2150000000000 13.26118437 1/02/2021 33114.57813 58330.57031 32384.22852 45137.76953 45137.76953 2270000000000 30.97523515 1/03/2021 45159.50391 61683.86328 45115.09375 58918.83203 58918.83203 1680000000000 26.64414105 1/04/2021 58926.5625 64863.09766 47159.48438 57750.17578 57750.17578 1840000000000 -2.00343752 1/05/2021 57714.66406 59519.35547 30681.49609 37332.85547 37332.85547 1980000000000 -43.62526106 1/06/2021 3 37293.79297 41295.26953 28893.62109 35040.83594 35040.83594 1190000000000 -6.33596601 1/07/2021 35035.98438 42235.54688 2 29360.95508 41626.19531 41626.19531 819000000000 17.22155415 1/08/2021 41460.84375 50482.07813 37458.00391 47166.6875 47166.6875 1010000000000 12.49582061 1/09/2021 47099.77344 52853.76563 39787.60938 43790.89453 43790.89453 1100000000000 -7.42619618 1/10/2021 4 43816.74219 66930.39063 43320.02344 61318.95703 61318.95703 1150000000000 33.66631369 1/11/2021 61320.44922 68789.625 53569.76563 57005.42578 57005.42578 1050000000000 -7.29425928 1/12/2021 56907.96484 59041.68359 42874.61719 50822.19531 50822.19531 766000000000 -11.48132777 26/12/2021 50450.29688 50683.20313 49933.45703 49933.45703 49933.45703 19784943616 -1.76419151Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started