Compute the monthly returns for HAS stock and those of the S&P. The…

QuestionAnswered step-by-stepCompute the monthly returns for HAS stock and those of the S&P. The…Compute the monthly returns for HAS stock and those of the S&P.  The data is listed below for each. HAS StockDate Open High Low Close Adj Close Volume2017-06-01 105.32 113.489998 104.910004 111.510002 96.878815 188238002017-07-01 112.089996 116.199997 103.68 105.879997 91.987541 218530002017-08-01 106.080002 106.800003 93.730003 98.25 85.81736 294958002017-09-01 98.449997 99.089996 91.57 97.669998 85.310768 281139002017-10-01 97.349998 98.93 88.660004 92.589996 80.873596 392254002017-11-01 92.900002 99.169998 87.919998 93.019997 81.737183 284725002017-12-01 92.639999 97.169998 90.029999 90.889999 79.865562 240629002018-01-01 91.559998 97.459999 88.300003 94.57 83.099182 338930002018-02-01 94.339996 103.389999 89.889999 95.57 84.488731 396709002018-03-01 96.059998 97.160004 83.559998 84.300003 74.525497 299779002018-04-01 83.970001 89.059998 79 88.089996 77.876045 407030002018-05-01 88 89.209999 85.309998 86.75 77.248505 205157002018-06-01 87.220001 93 86.279999 92.309998 82.199524 222955002018-07-01 91.75 107.580002 91.699997 99.610001 88.699982 396603002018-08-01 99.379997 102.519997 97.220001 99.309998 88.998055 159770002018-09-01 98.75 109.599998 98.650002 105.120003 94.20475 205612002018-10-01 106.110001 107.57 89.889999 91.709999 82.187195 396138002018-11-01 92.050003 100.849998 90.970001 91 82.114212 242387002018-12-01 91.470001 91.510002 76.839996 81.25 73.316246 277034002019-01-01 79.889999 91.540001 77.339996 90.559998 81.717171 233754002019-02-01 90.540001 93.190002 82.879997 84.900002 77.143631 343006002019-03-01 85.790001 90.040001 82.870003 85.019997 77.252655 198484002019-04-01 85.459999 103.599998 84.610001 101.860001 92.554176 293820002019-05-01 101.900002 105 95.099998 95.139999 87.029907 217647002019-06-01 95.209999 108.860001 94.580002 105.68 96.67144 173273002019-07-01 106.699997 126.870003 104.470001 121.160004 110.831848 245749002019-08-01 121.589996 122.190002 103.040001 110.470001 101.608627 212112002019-09-01 109.82 121.480003 108.089996 118.690002 109.16925 153846002019-10-01 118.949997 123.050003 94.190002 97.309998 89.50425 319590002019-11-01 97.790001 102.699997 92.589996 101.699997 94.187172 358312002019-12-01 102.599998 106.269997 98.07 105.610001 97.808334 204931002020-01-01 106.169998 106.25 100.620003 101.870003 94.344597 208276002020-02-01 102.690002 109.5 75.629997 77.25 72.012878 337992002020-03-01 77.32 80.120003 41.330002 71.550003 66.699318 529679002020-04-01 68.040001 80.489998 66.470001 72.209999 67.314583 323953002020-05-01 70.650002 74.959999 60.200001 73.510002 69.171577 226263002020-06-01 73.559998 83.989998 69.330002 74.949997 70.526588 255403002020-07-01 74.690002 80.800003 70.779999 72.760002 68.465851 231298002020-08-01 72.959999 82.080002 72.279999 78.940002 74.976654 136368002020-09-01 78.57 85.82 75.25 82.720001 78.566879 203575002020-10-01 82.989998 92.949997 80.239998 82.720001 78.566879 236696002020-11-01 83.529999 94.300003 82.010002 93.029999 89.081505 172571002020-12-01 94.339996 97.129997 87.519997 93.540001 89.569847 208437002021-01-01 93.739998 101.239998 90.389999 93.82 89.837975 151611002021-02-01 93.75 99.68 89.160004 93.709999 89.732643 206879002021-03-01 94.139999 99.489998 90.32 96.120003 92.712318 211423002021-04-01 96.25 100.510002 94.360001 99.449997 95.924263 192353002021-05-01 99.709999 101.099998 92.75 95.970001 93.207268 128392002021-06-01 96.5 97.639999 90.550003 94.519997 91.799011 144714002021-07-01 94.900002 104.889999 90.82 99.440002 96.577377 191745002021-08-01 100.07 101.599998 94.290001 98.309998 96.130409 111795002021-09-01 98.540001 100.949997 88.82 89.220001 87.241943 124146002021-10-01 89.279999 96.669998 86.050003 95.760002 93.636948 217835002021-11-01 95.879997 101.199997 92.07 96.910004 95.433311 140187002021-12-01 97.57 102.790001 95.099998 101.779999 100.229095 157031002022-01-01 102.220001 105.730003 85.970001 92.480003 91.070816 230107002022-02-01 92.75 105.129997 89.660004 97.050003 96.299011 271189002022-03-01 96.559998 97.550003 81.160004 81.919998 81.286079 310700002022-04-01 82.339996 92.519997 81.839996 88.059998 87.378571 265253002022-05-01 87.879997 94.220001 86.599998 86.760002 86.760002 14819400S&P 500 Date Open High Low Close* Adj Close** Volume20-May-22 3,927.76 3,943.42 3,810.32 3,901.36 3,901.36 3,002,384,0001-May-22 4,130.61 4,307.66 3,810.32 3,901.36 3,901.36 64,796,810,0001-Apr-22 4,540.32 4,593.45 4,124.28 4,131.93 4,131.93 74,784,850,0001-Mar-22 4,363.14 4,637.30 4,157.87 4,530.41 4,530.41 100,978,320,0001-Feb-22 4,519.57 4,595.31 4,114.65 4,373.94 4,373.94 73,167,790,0001-Jan-22 4,778.14 4,818.62 4,222.62 4,515.55 4,515.55 73,279,440,0001-Dec-21 4,602.82 4,808.93 4,495.12 4,766.18 4,766.18 68,699,830,0001-Nov-21 4,610.62 4,743.83 4,560.00 4,567.00 4,567.00 67,520,800,0001-Oct-21 4,317.16 4,608.08 4,278.94 4,605.38 4,605.38 61,874,700,0001-Sep-21 4,528.80 4,545.85 4,305.91 4,307.54 4,307.54 66,268,850,0001-Aug-21 4,406.86 4,537.36 4,367.73 4,522.68 4,522.68 63,217,960,0001-Jul-21 4,300.73 4,429.97 4,233.13 4,395.26 4,395.26 66,496,430,0001-Jun-21 4,216.52 4,302.43 4,164.40 4,297.50 4,297.50 85,705,180,0001-May-21 4,191.98 4,238.04 4,056.88 4,204.11 4,204.11 75,155,370,0001-Apr-21 3,992.78 4,218.78 3,992.78 4,181.17 4,181.17 82,869,290,0001-Mar-21 3,842.51 3,994.41 3,723.34 3,972.89 3,972.89 120,863,560,0001-Feb-21 3,731.17 3,950.43 3,725.62 3,811.15 3,811.15 98,596,960,0001-Jan-21 3,764.61 3,870.90 3,662.71 3,714.24 3,714.24 105,548,790,0001-Dec-20 3,645.87 3,760.20 3,633.40 3,756.07 3,756.07 96,056,410,0001-Nov-20 3,296.20 3,645.99 3,279.74 3,621.63 3,621.63 100,977,880,0001-Oct-20 3,385.87 3,549.85 3,233.94 3,269.96 3,269.96 89,737,600,0001-Sep-20 3,507.44 3,588.11 3,209.45 3,363.00 3,363.00 92,084,120,0001-Aug-20 3,288.26 3,514.77 3,284.53 3,500.31 3,500.31 84,402,300,0001-Jul-20 3,105.92 3,279.99 3,101.17 3,271.12 3,271.12 97,197,020,0001-Jun-20 3,038.78 3,233.13 2,965.66 3,100.29 3,100.29 131,044,000,0001-May-20 2,869.09 3,068.67 2,766.64 3,044.31 3,044.31 106,799,100,0001-Apr-20 2,498.08 2,954.86 2,447.49 2,912.43 2,912.43 123,163,450,0001-Mar-20 2,974.28 3,136.72 2,191.86 2,584.59 2,584.59 161,801,100,0001-Feb-20 3,235.66 3,393.52 2,855.84 2,954.22 2,954.22 84,292,270,0001-Jan-20 3,244.67 3,337.77 3,214.64 3,225.52 3,225.52 77,104,420,0001-Dec-19 3,143.85 3,247.93 3,070.33 3,230.78 3,230.78 72,054,000,0001-Nov-19 3,050.72 3,154.26 3,050.72 3,140.98 3,140.98 72,179,920,0001-Oct-19 2,983.69 3,050.10 2,855.94 3,037.56 3,037.56 77,564,550,0001-Sep-19 2,909.01 3,021.99 2,891.85 2,976.74 2,976.74 73,992,330,0001-Aug-19 2,980.32 3,013.59 2,822.12 2,926.46 2,926.46 79,599,440,0001-Jul-19 2,971.41 3,027.98 2,952.22 2,980.38 2,980.38 70,349,470,0001-Jun-19 2,751.53 2,964.15 2,728.81 2,941.76 2,941.76 70,904,280,0001-May-19 2,952.33 2,954.13 2,750.52 2,752.06 2,752.06 76,860,120,0001-Apr-19 2,848.63 2,949.52 2,848.63 2,945.83 2,945.83 69,604,840,0001-Mar-19 2,798.22 2,860.31 2,722.27 2,834.40 2,834.40 78,596,280,0001-Feb-19 2,702.32 2,813.49 2,681.83 2,784.49 2,784.49 70,183,430,0001-Jan-19 2,476.96 2,708.95 2,443.96 2,704.10 2,704.10 80,401,630,0001-Dec-18 2,790.50 2,800.18 2,346.58 2,506.85 2,506.85 83,522,570,0001-Nov-18 2,717.58 2,815.15 2,631.09 2,760.17 2,760.17 80,080,110,0001-Oct-18 2,926.29 2,939.86 2,603.54 2,711.74 2,711.74 91,327,930,0001-Sep-18 2,896.96 2,940.91 2,864.12 2,913.98 2,913.98 62,492,080,0001-Aug-18 2,821.17 2,916.50 2,796.34 2,901.52 2,901.52 69,238,220,0001-Jul-18 2,704.95 2,848.03 2,698.95 2,816.29 2,816.29 64,542,170,0001-Jun-18 2,718.70 2,791.47 2,691.99 2,718.37 2,718.37 77,439,710,0001-May-18 2,642.96 2,742.24 2,594.62 2,705.27 2,705.27 75,617,280,0001-Apr-18 2,633.45 2,717.49 2,553.80 2,648.05 2,648.05 69,648,590,0001-Mar-18 2,715.22 2,801.90 2,585.89 2,640.87 2,640.87 76,369,800,0001-Feb-18 2,816.45 2,835.96 2,532.69 2,713.83 2,713.83 79,579,410,0001-Jan-18 2,683.73 2,872.87 2,682.36 2,823.81 2,823.81 76,860,120,0001-Dec-17 2,645.10 2,694.97 2,605.52 2,673.61 2,673.61 65,251,190,0001-Nov-17 2,583.21 2,657.74 2,557.45 2,647.58 2,647.58 73,173,260,0001-Oct-17 2,521.20 2,582.98 2,520.40 2,575.26 2,575.26 70,871,570,0001-Sep-17 2,474.42 2,519.44 2,446.55 2,519.36 2,519.36 66,337,980,0001-Aug-17 2,477.10 2,490.87 2,417.35 2,471.65 2,471.65 70,616,030,0001-Jul-17 2,431.39 2,484.04 2,407.70 2,470.30 2,470.30 63,169,400,0001-Jun-17 2,415.65 2,453.82 2,405.70 2,423.41 2,423.41 81,002,490,000Please show how to compute in Excel. Thank you.MathStatistics and ProbabilitySTAT MISCShare Question