Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the sample mean, standard deviation, skewness, minimum, maximum and range of each log-return series. No. Date Open High Low Close Adj Close Volume F(x)

image text in transcribed

Calculate the sample mean, standard deviation, skewness, minimum, maximum and range of each log-return series.

image text in transcribed
No. Date Open High Low Close Adj Close Volume F(x) Log Returns 1 1/10/2015 236.003998 334.169006 235.615997 314.165985 314.165985 953279500 299487993097.81 1/11/2015 315.005005 495.562012 300.997009 377.321014 377.321014 2177623396 821663067888.84 0.18317486 W N 1/12/2015 377.414001 469.102997 349.464996 430.566986 430.566986 2096250000 902576044402.50 0.13200659 4 1/01/2016 430.721008 462.93399 354.914001 368.766998 368.766998 1990880304 734170953083.41 -0.15493791 1/02/2016 369.350006 448.04599 367.957001 437.696991 437.696991 1876238692 821224029886.18 0.17136187 1/03/2016 437.916992 439.653015 394.03500 416.729004 416.729004 2332852776 972167413821.12 -0.04909073 1/04/2016 416.76001 467.964996 415.830994 448.317993 448.317993 1811475204 812116927826.55 0.07306665 00 1/05/2016 448.484009 $53.960022 437.389008 531.385986 531.385986 2234432796 1187346274453.20 0.16998587 1/06/2016 531.106995 777.98999 525.635986 673.336975 673.336975 4749702740 3198150475100.81 0.23675725 10 1/07/2016 672.515015 704.968018 611.833984 624.68103 624.68103 3454186204 2157764595726.51 -0.07500474 11 1/08/2016 624.60199 626.119019 531.333984 575.471985 575.471985 2686220180 1545844459131.66 -0.08205062 12 1/09/2016 575.546021 628.817993 570.810974 609.734985 609.734985 2004401400 1222153657562.98 0.05783386 3 1/10/2016 609.929016 720.401978 609.479004 700.971985 700.971985 2115443796 1482866836838.06 0.13944351 14 1/11/2016 701.336975 756.237 678.156006 745.690979 745.690979 2635773092 1965472217395.34 0.06184336 15 1/12/2016 746.046021 979.396973 746.046021 963.742981 963.742981 3556763800 3427806147324.89 0.25651336 16 1/01/2017 802 1191.099976 755.755981 970.403015 970.403015 5143971692 4991725638991.45 0.00688682 17 1/02/2017 970.940979 1200.390015 946.690979 1179.969971 1179.969971 4282761200 5053529608963.92 0.19553280 18 1/03/2017 1180.040039 1280.310059 903.713013 1071.790039 1071.790039 10872455960 11652989997394.20 -0.09615881 19 1/04/2017 1071.709961 1347.910034 1061.089966 1347.890015 1347.890015 9757448112 13151966882045.40 0.22921023 20 1/05/2017 1348.300049 2763.709961 1348.300049 2286.409912 2286.409912 34261856864 78336649137374.80 0.52844245 21 1/06/2017 2288.330078 2999.909912 2212.959961 2480.840088 2480.840088 44478140928 110343155053896.00 0.08161438 22 1/07/2017 2492.600098 2916.139893 1843.030029 2875.340088 2875.340088 32619956992 93793470007933.50 0.14757371 23 1/08/2017 2871.300049 4736.049805 2668.590088 8 4703.390137 4703.390137 63548016640 298891114690488.00 0.49211260 24 1/09/2017 4701.759766 4975.040039 2946.620117 4338.709961 4338.709961 55700949056 241670262506421.00 -0.08070649 25 1/10/2017 4341.049805 6470.430176 4164.049805 6468.399902 6468.399902 58009357952 375227725291800.00 0.39935171 26 1/11/2017 7446.830078 11517.40039 5519.009766 10233.59961 10233.59961 115000000000 1176863955150000.00 0.45874762 27 1/12/2017 10198.59961 20089 9694.650391 14156.40039 14156.40039 410000000000 5804124159900000.00 0.32449046 28 1/01/2018 14112.2002 17712.40039 9402.290039 10221.09961 10221.09961 416000000000 4251977437760000.00 -0.32571267 29 1/02/2018 10237.29981 11958.5 6048.259766 10397.90039 10397.90039 230000000000 2391517089700000.00 0.01714973 30 1/03/2018 10385 11704.09961 6683.930176 6973.529785 6973.529785 194000000000 1352864778290000.00 -0.39948238 31 1/04/2018 7003.060059 9745.320313 6526.870117 9240.549805 9240.549805 197000000000 1820388311585000.00 0.28147986 32 1/05/2018 9251.469727 9964.5 7090.680176 7494.169922 7494.169922 198000000000 1483845644556000.00 -0.20947601 33 1/06/2018 7500.700195 7754.890137 5826.410156 6404 6404 130000000000 832520000000000.00 -0.15720258 34 1/07/2018 6411.680176 8424.269531 6136.419922 7780.439941 7780.439941 141000000000 1097042031681000.00 0.19469009 35 1/08/2018 7769.040039 7769.040039 5971.049805 7037.580078 7037.580078 13200000000 928960570296000.00 -0.10034851 36 1/09/2018 7044.810059 7388.430176 6197.52002 6625.560059 6625.560059 130000000000 861322807670000.00 -0.06032947 37 1/10/2018 6619.850098 6965.060059 6236.470215 6317.609863 6317.609863 118000000000 745477963834000.00 -0.04759396 38 1/11/2018 6318.140137 6552.160156 3585.060059 4017.268555 4017.268555 158000000000 634728431690000.00 -0.45273874 39 1/12/2018 4024.464355 4309.377441 3191.303467 3742.700439 3742.700439 169000000000 632516374191000.00 -0.07079481 40 1/01/2019 3746.713379 4109.020996 3400.819824 3457.792725 3457.792725 167000000000 577451385075000.00 -0.07917695 41 1/02/2019 3460.547119 4210.641602 3391.023682 3854.7854 3854.7854 199000000000 767102294600000.00 0.10868489 1/03/2019 3853.75708 4296.806641 3733.749756 4105.404297 4105.404297 298000000000 1223410480506000.00 0.06298889 43 1/04/2019 4105.362305 5642.044434 4096.901367 5350.726563 5350.726563 445000000000 2381073320535000.00 0.26492813 44 1/05/2019 5350.914551 9008.314453 5347.645996 8574.501953 8574.501953 724000000000 6207939413972000.00 0.47156055 45 1/06/2019 8573.839844 13796.48926 7564.48877 10817.15527 10817.15527 676000000000 7312396962520000.00 0.23234041 46 1/07/2019 10796.93066 13129.5293 9163.134766 10085.62793 10085.62793 676000000000 6817884480680000.00 -0.07002189 47 1/08/2019 10077.44238 12273.82129 9421.629883 9630.664063 9630.664063 534000000000 5142774609642000.00 -0.04615925 48 1/09/2019 9630.592773 10898.76172 7830.758789 8293.868164 8293.868164 481000000000 3989350586884000.00 -0.14943571 49 1/10/2019 8299.720703 10021.74414 7446.98877 9199.584961 9199.584961 595000000000 5473753051795000.00 0.10364190 50 1/11/2019 9193.992188 9505.051758 6617.166992 7569.629883 7569.629883 677000000000 5124639430791000.00 -0.19501420 51 1/12/2019 7571.616211 7743.431641 6540.049316 7193.599121 7193.599121 634000000000 4560741842714000.00 -0.05095255 52 1/01/2020 7194.89209 9553.125977 6914.996094 9350.529297 9350.529297 853000000000 7976001490341000.00 0.26224133 53 1/02/2020 9346.357422 10457.62695 8492.932617 8599.508789 8599.508789 1160000000000 9975430195240000.00 0.08372787 54 1/03/2020 8599.758789 9167.695313 4106.980957 6438.644531 6438.644531 1290000000000 8305851444990000.00 -0.28938704 55 1/04/2020 6437.319336 9440.650391 6202.373535 8658.553711 8658.553711 1160000000000 10043922304760000.00 0.29622966 56 1/05/2020 8672.782227 9996.743164 8374.323242 9461.058594 9461.058594 1290000000000 12204765586260000.00 0.08863658 57 1/06/2020 9463.605469 10199.56543 8975.525391 9137.993164 9137.993164 651000000000 5948833549764000.00 -0.03474348 58 1/07/2020 9145.985352 11415.86426 8977.015625 11323.4668 11323.4668 546000000000 6182612872800000.00 0.21443649 59 1/08/2020 11322.57031 12359.05664 11012.41504 11680.82031 11680.82031 708000000000 8270020779480000.00 0.03107093 60 1/09/2020 11679.31641 12067.08106 9916.493164 10784.49121 10784.49121 1080000000000 11647250506800000.00 -0.07983910 61 1/10/2020 10795.25488 14028.21387 10416.68945 13780.99512 13780.99512 1050000000000 14470044876000000.00 0.24518137 62 1/11/2020 13780.99512 19749.26367 13243.16016 19625.83594 19625.83594 1090000000000 21392161174600000.00 0.35355638 1/12/2020 19633.76953 29244.87695 17619.5332 29001.7207 29001.7207 1210000000000 35092082047000000.00 0.39050830 64 1/01/2021 28994.00977 41946.73828 28722.75586 33114.35938 33114.35938 2150000000000 71195872667000000.00 0.13261184 65 1/02/2021 33114.57813 58330.57031 32384.22852 45137.76953 45137.76953 2270000000000 102462736833100000.00 0.30975235 66 1/03/2021 45159.50391 61683.86328 45115.09375 58918.83203 58918.83203 1680000000000 98983637810400000.00 0.26644141 67 1/04/2021 58926.5625 64863.09766 47159.48438 57750.17578 57750.17578 1840000000000 106260323435200000.00 -0.02003438 68 1/05/2021 57714.66406 59519.35547 30681.49609 37332.85547 37332.85547 1980000000000 73919053830600000.00 -0.43625261 69 1/06/2021 37293.79297 41295.26953 28893.62109 35040.83594 35040.83594 1190000000000 41698594768600000.00 -0.06335966 70 1/07/2021 35035.98438 42235.54688 29360.95508 41626.19531 41626.19531 819000000000 34091853958890000.00 0.17221554 1 1/08/2021 41460.84375 50482.07813 37458.00391 47166.6875 47166.6875 1010000000000 47638354375000000.00 0.12495821 72 1/09/2021 47099.77344 52853.76563 39787.60938 43790.89453 43790.89453 1100000000000 48169983983000000.00 -0.07426196 73 1/10/2021 43816.74219 66930.39063 43320.02344 61318.95703 61318.95703 1150000000000 70516800584500000.00 0.33666314 74 1/11/2021 61320.44922 68789.625 53569.76563 57005.42578 57005.42578 1050000000000 59855697069000000.00 -0.07294259 75 1/12/2021 56907.96484 59041.68359 42874.61719 50822.19531 50822.19531 766000000000 38929801607460000.00 -0.11481328 76 26/12/2021 50450.29688 50683.20313 49933.45703 49933.45703 49933.45703 19784943616 987930631890509.00 -0.01764192

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Mathematics questions