Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compute the monthly returns for HAS stock and those of the S&P. The data is listed below for each. HAS Stock Date Open High Low

Compute the monthly returns for HAS stock and those of the S&P. The data is listed below for each.

HAS Stock

Date Open High Low Close Adj Close Volume
2017-06-01 105.32 113.489998 104.910004 111.510002 96.878815 18823800
2017-07-01 112.089996 116.199997 103.68 105.879997 91.987541 21853000
2017-08-01 106.080002 106.800003 93.730003 98.25 85.81736 29495800
2017-09-01 98.449997 99.089996 91.57 97.669998 85.310768 28113900
2017-10-01 97.349998 98.93 88.660004 92.589996 80.873596 39225400
2017-11-01 92.900002 99.169998 87.919998 93.019997 81.737183 28472500
2017-12-01 92.639999 97.169998 90.029999 90.889999 79.865562 24062900
2018-01-01 91.559998 97.459999 88.300003 94.57 83.099182 33893000
2018-02-01 94.339996 103.389999 89.889999 95.57 84.488731 39670900
2018-03-01 96.059998 97.160004 83.559998 84.300003 74.525497 29977900
2018-04-01 83.970001 89.059998 79 88.089996 77.876045 40703000
2018-05-01 88 89.209999 85.309998 86.75 77.248505 20515700
2018-06-01 87.220001 93 86.279999 92.309998 82.199524 22295500
2018-07-01 91.75 107.580002 91.699997 99.610001 88.699982 39660300
2018-08-01 99.379997 102.519997 97.220001 99.309998 88.998055 15977000
2018-09-01 98.75 109.599998 98.650002 105.120003 94.20475 20561200
2018-10-01 106.110001 107.57 89.889999 91.709999 82.187195 39613800
2018-11-01 92.050003 100.849998 90.970001 91 82.114212 24238700
2018-12-01 91.470001 91.510002 76.839996 81.25 73.316246 27703400
2019-01-01 79.889999 91.540001 77.339996 90.559998 81.717171 23375400
2019-02-01 90.540001 93.190002 82.879997 84.900002 77.143631 34300600
2019-03-01 85.790001 90.040001 82.870003 85.019997 77.252655 19848400
2019-04-01 85.459999 103.599998 84.610001 101.860001 92.554176 29382000
2019-05-01 101.900002 105 95.099998 95.139999 87.029907 21764700
2019-06-01 95.209999 108.860001 94.580002 105.68 96.67144 17327300
2019-07-01 106.699997 126.870003 104.470001 121.160004 110.831848 24574900
2019-08-01 121.589996 122.190002 103.040001 110.470001 101.608627 21211200
2019-09-01 109.82 121.480003 108.089996 118.690002 109.16925 15384600
2019-10-01 118.949997 123.050003 94.190002 97.309998 89.50425 31959000
2019-11-01 97.790001 102.699997 92.589996 101.699997 94.187172 35831200
2019-12-01 102.599998 106.269997 98.07 105.610001 97.808334 20493100
2020-01-01 106.169998 106.25 100.620003 101.870003 94.344597 20827600
2020-02-01 102.690002 109.5 75.629997 77.25 72.012878 33799200
2020-03-01 77.32 80.120003 41.330002 71.550003 66.699318 52967900
2020-04-01 68.040001 80.489998 66.470001 72.209999 67.314583 32395300
2020-05-01 70.650002 74.959999 60.200001 73.510002 69.171577 22626300
2020-06-01 73.559998 83.989998 69.330002 74.949997 70.526588 25540300
2020-07-01 74.690002 80.800003 70.779999 72.760002 68.465851 23129800
2020-08-01 72.959999 82.080002 72.279999 78.940002 74.976654 13636800
2020-09-01 78.57 85.82 75.25 82.720001 78.566879 20357500
2020-10-01 82.989998 92.949997 80.239998 82.720001 78.566879 23669600
2020-11-01 83.529999 94.300003 82.010002 93.029999 89.081505 17257100
2020-12-01 94.339996 97.129997 87.519997 93.540001 89.569847 20843700
2021-01-01 93.739998 101.239998 90.389999 93.82 89.837975 15161100
2021-02-01 93.75 99.68 89.160004 93.709999 89.732643 20687900
2021-03-01 94.139999 99.489998 90.32 96.120003 92.712318 21142300
2021-04-01 96.25 100.510002 94.360001 99.449997 95.924263 19235300
2021-05-01 99.709999 101.099998 92.75 95.970001 93.207268 12839200
2021-06-01 96.5 97.639999 90.550003 94.519997 91.799011 14471400
2021-07-01 94.900002 104.889999 90.82 99.440002 96.577377 19174500
2021-08-01 100.07 101.599998 94.290001 98.309998 96.130409 11179500
2021-09-01 98.540001 100.949997 88.82 89.220001 87.241943 12414600
2021-10-01 89.279999 96.669998 86.050003 95.760002 93.636948 21783500
2021-11-01 95.879997 101.199997 92.07 96.910004 95.433311 14018700
2021-12-01 97.57 102.790001 95.099998 101.779999 100.229095 15703100
2022-01-01 102.220001 105.730003 85.970001 92.480003 91.070816 23010700
2022-02-01 92.75 105.129997 89.660004 97.050003 96.299011 27118900
2022-03-01 96.559998 97.550003 81.160004 81.919998 81.286079 31070000
2022-04-01 82.339996 92.519997 81.839996 88.059998 87.378571 26525300
2022-05-01 87.879997 94.220001 86.599998 86.760002 86.760002 14819400

S&P 500

Date Open High Low Close* Adj Close** Volume
20-May-22 3,927.76 3,943.42 3,810.32 3,901.36 3,901.36 3,002,384,000
1-May-22 4,130.61 4,307.66 3,810.32 3,901.36 3,901.36 64,796,810,000
1-Apr-22 4,540.32 4,593.45 4,124.28 4,131.93 4,131.93 74,784,850,000
1-Mar-22 4,363.14 4,637.30 4,157.87 4,530.41 4,530.41 100,978,320,000
1-Feb-22 4,519.57 4,595.31 4,114.65 4,373.94 4,373.94 73,167,790,000
1-Jan-22 4,778.14 4,818.62 4,222.62 4,515.55 4,515.55 73,279,440,000
1-Dec-21 4,602.82 4,808.93 4,495.12 4,766.18 4,766.18 68,699,830,000
1-Nov-21 4,610.62 4,743.83 4,560.00 4,567.00 4,567.00 67,520,800,000
1-Oct-21 4,317.16 4,608.08 4,278.94 4,605.38 4,605.38 61,874,700,000
1-Sep-21 4,528.80 4,545.85 4,305.91 4,307.54 4,307.54 66,268,850,000
1-Aug-21 4,406.86 4,537.36 4,367.73 4,522.68 4,522.68 63,217,960,000
1-Jul-21 4,300.73 4,429.97 4,233.13 4,395.26 4,395.26 66,496,430,000
1-Jun-21 4,216.52 4,302.43 4,164.40 4,297.50 4,297.50 85,705,180,000
1-May-21 4,191.98 4,238.04 4,056.88 4,204.11 4,204.11 75,155,370,000
1-Apr-21 3,992.78 4,218.78 3,992.78 4,181.17 4,181.17 82,869,290,000
1-Mar-21 3,842.51 3,994.41 3,723.34 3,972.89 3,972.89 120,863,560,000
1-Feb-21 3,731.17 3,950.43 3,725.62 3,811.15 3,811.15 98,596,960,000
1-Jan-21 3,764.61 3,870.90 3,662.71 3,714.24 3,714.24 105,548,790,000
1-Dec-20 3,645.87 3,760.20 3,633.40 3,756.07 3,756.07 96,056,410,000
1-Nov-20 3,296.20 3,645.99 3,279.74 3,621.63 3,621.63 100,977,880,000
1-Oct-20 3,385.87 3,549.85 3,233.94 3,269.96 3,269.96 89,737,600,000
1-Sep-20 3,507.44 3,588.11 3,209.45 3,363.00 3,363.00 92,084,120,000
1-Aug-20 3,288.26 3,514.77 3,284.53 3,500.31 3,500.31 84,402,300,000
1-Jul-20 3,105.92 3,279.99 3,101.17 3,271.12 3,271.12 97,197,020,000
1-Jun-20 3,038.78 3,233.13 2,965.66 3,100.29 3,100.29 131,044,000,000
1-May-20 2,869.09 3,068.67 2,766.64 3,044.31 3,044.31 106,799,100,000
1-Apr-20 2,498.08 2,954.86 2,447.49 2,912.43 2,912.43 123,163,450,000
1-Mar-20 2,974.28 3,136.72 2,191.86 2,584.59 2,584.59 161,801,100,000
1-Feb-20 3,235.66 3,393.52 2,855.84 2,954.22 2,954.22 84,292,270,000
1-Jan-20 3,244.67 3,337.77 3,214.64 3,225.52 3,225.52 77,104,420,000
1-Dec-19 3,143.85 3,247.93 3,070.33 3,230.78 3,230.78 72,054,000,000
1-Nov-19 3,050.72 3,154.26 3,050.72 3,140.98 3,140.98 72,179,920,000
1-Oct-19 2,983.69 3,050.10 2,855.94 3,037.56 3,037.56 77,564,550,000
1-Sep-19 2,909.01 3,021.99 2,891.85 2,976.74 2,976.74 73,992,330,000
1-Aug-19 2,980.32 3,013.59 2,822.12 2,926.46 2,926.46 79,599,440,000
1-Jul-19 2,971.41 3,027.98 2,952.22 2,980.38 2,980.38 70,349,470,000
1-Jun-19 2,751.53 2,964.15 2,728.81 2,941.76 2,941.76 70,904,280,000
1-May-19 2,952.33 2,954.13 2,750.52 2,752.06 2,752.06 76,860,120,000
1-Apr-19 2,848.63 2,949.52 2,848.63 2,945.83 2,945.83 69,604,840,000
1-Mar-19 2,798.22 2,860.31 2,722.27 2,834.40 2,834.40 78,596,280,000
1-Feb-19 2,702.32 2,813.49 2,681.83 2,784.49 2,784.49 70,183,430,000
1-Jan-19 2,476.96 2,708.95 2,443.96 2,704.10 2,704.10 80,401,630,000
1-Dec-18 2,790.50 2,800.18 2,346.58 2,506.85 2,506.85 83,522,570,000
1-Nov-18 2,717.58 2,815.15 2,631.09 2,760.17 2,760.17 80,080,110,000
1-Oct-18 2,926.29 2,939.86 2,603.54 2,711.74 2,711.74 91,327,930,000
1-Sep-18 2,896.96 2,940.91 2,864.12 2,913.98 2,913.98 62,492,080,000
1-Aug-18 2,821.17 2,916.50 2,796.34 2,901.52 2,901.52 69,238,220,000
1-Jul-18 2,704.95 2,848.03 2,698.95 2,816.29 2,816.29 64,542,170,000
1-Jun-18 2,718.70 2,791.47 2,691.99 2,718.37 2,718.37 77,439,710,000
1-May-18 2,642.96 2,742.24 2,594.62 2,705.27 2,705.27 75,617,280,000
1-Apr-18 2,633.45 2,717.49 2,553.80 2,648.05 2,648.05 69,648,590,000
1-Mar-18 2,715.22 2,801.90 2,585.89 2,640.87 2,640.87 76,369,800,000
1-Feb-18 2,816.45 2,835.96 2,532.69 2,713.83 2,713.83 79,579,410,000
1-Jan-18 2,683.73 2,872.87 2,682.36 2,823.81 2,823.81 76,860,120,000
1-Dec-17 2,645.10 2,694.97 2,605.52 2,673.61 2,673.61 65,251,190,000
1-Nov-17 2,583.21 2,657.74 2,557.45 2,647.58 2,647.58 73,173,260,000
1-Oct-17 2,521.20 2,582.98 2,520.40 2,575.26 2,575.26 70,871,570,000
1-Sep-17 2,474.42 2,519.44 2,446.55 2,519.36 2,519.36 66,337,980,000
1-Aug-17 2,477.10 2,490.87 2,417.35 2,471.65 2,471.65 70,616,030,000
1-Jul-17 2,431.39 2,484.04 2,407.70 2,470.30 2,470.30 63,169,400,000
1-Jun-17 2,415.65 2,453.82 2,405.70 2,423.41 2,423.41 81,002,490,000

Please show how to compute in Excel. Thank you.

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Sampling

Authors: Steven K Thompson

3rd Edition

111816296X, 9781118162965

More Books

Students also viewed these Mathematics questions

Question

How would you describe Benton's culture? Discuss.

Answered: 1 week ago