Question: 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)

Calculate the sample mean, standard deviation, skewness, minimum, maximum and range

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

of each log-return series. No. Date Open High Low Close Adj Close

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

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...

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) Log Returns 1 1/10/2015 236.003998...

Calculate the sample mean, standard deviation, skewness, minimum, maximum and range of each log-return series. No. 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40...

BTC-USD Date Open High Low Close Adj Close Volume Log Returns Column1 1/10/2015 236.003998 334.169006 235.615997 314.165985 314.165985 95327950 1/11/2015 315.005005 495.562012 300.997009 377.321014...

Date Open High Low Close Adj Close Volume Rate of return 1-Feb-18 78.27 79.23 71 75.49 64.39 345,124,100 1-Mar-18 75.5 76.53 67.5 67.5 57.81 397,762,100 -0.102189781 31-Mar-18 68.33 73.38 66.55 68.27...

Questions for Coca Cola Case Can you find an error in equation 1 Look at Figure 1, how well does the regression line predict the actual results? What does the R2 in the regression equation (table1)...

What are the distinguishing features of a money market instrument?

Tree Seedlings has the following current-year purchases and sales for its only product.r The company uses a periodic inventory system. a. Determine the costs assigned to ending inventory and to cost...

Explain the rule in Foss v Harbottle and describe the limits to this rule. (The Institute of Company Accountants)

Please help it's urgent thank you. please write 400-450 words. thank you QUESTION 4 (20 MARKS) The success of any project is dependent on a diverse range of skills, abilities and competencies of the...

2. A Soviet invasion of Poland would lead to the severing of diplomatic relations between the United States and the Soviet Union.

1. Diplomatic relations between the United States and the Soviet Union would be severed in 1993 than that

1. To provide knowledge about various influencing techniques in communication situations.