Price Data Date S P 500 Amazon com January 10 1073 87 $ 125 41 February 10 1104 49 $ 118 40 2 85 5 59 March 10 1169 43 $ 135 77 5 88 14 67 April 10 1186 69 $ 137 10 1 48 0 98 May 10 1089 41 $ 125 46 8 20 8 49 June 10 1030 71 $ 109 26 5 39 12 91 July 10 1101 6 $ 117 89 6 88 7 90 August 10 1049 33 $ 124 83 4 74 5 89 September 10 1141 2 $ 157 06 8 76 25 82 October 10 1183 26 $ 165 23 3 69 5 20 November 10 1180 55 $ 175 40 0 23 6 16 December 10 1257 64 $ 180 00 6 53 2 62 January 11 1286 12 $ 169 64 2 26 5 76 February 11 1327 22 $ 173 29 3 20 2 15 March 11 1325 83 $ 180 13 0 10 3 95 April 11 1363 61 $ 195 81 2 85 8 70 May 11 1345 2 $ 196 69 1 35 0 45 June 11 1320 64 $ 204 49 1 83 3 97 July 11 1292 28 $ 222 52 2 15 8 82 August 11 1218 89 $ 215 23 5 68 3 28 September 11 1131 42 $ 216 23 7 18 0 46 October 11 1253 3 $ 213 51 10 77 1 26 November 11 1246 96 $ 192 29 0 51 9 94 December 11 1257 6 $ 173 10 0 85 9 98 January 12 1312 41 $ 194 44 4 36 12 33 February 12 1365 68 $ 179 69 4 06 7 59 March 12 1408 47 $ 202 51 3 13 12 70 April 12 1397 91 $ 231 90 0 75 14 51 May 12 1310 33 $ 212 91 6 27 8 19 June 12 1362 16 $ 228 35 3 96 7 25 July 12 1379 32 $ 233 30 1 26 2 17 August 12 1406 58 $ 248 27 1 98 6 42 September 12 1440 67 $ 254 32 2 42 2 44 October 12 1412 16 $ 232 89 1 98 8 43 November 12 1416 18 $ 252 05 0 28 8 23 December 12 1426 19 $ 250 87 0 71 0 47 January 13 1498 11 $ 265 50 5 04 5 83 February 13 1514 68 $ 264 27 1 11 0 46 March 13 1569 19 $ 266 49 3 60 0 84 April 13 1597 57 $ 253 81 1 81 4 76 May 13 1630 74 $ 269 20 2 08 6 06 June 13 1606 28 $ 277 69 1 50 3 15 July 13 1685 73 $ 301 22 4 95 8 47 August 13 1632 97 $ 280 98 3 13 6 72 September 13 1681 55 $ 312 64 2 97 11 27 October 13 1756 54 $ 364 03 4 46 16 44 November 13 1805 81 $ 393 62 2 80 8 13 December 13 1848 36 $ 398 79 2 36 1 31 January 14 1782 59 $ 358 69 3 56 10 06 February 14 1859 45 $ 362 10 4 31 0 95 March 14 1872 34 $ 336 37 0 69 7 11 April 14 1883 95 $ 304 13 0 62 9 58 May 14 1923 57 $ 312 55 2 10 2 77 June 14 1960 23 $ 324 78 1 91 3 91 July 14 1930 67 $ 312 99 1 51 3 63 August 14 2003 37 $ 339 04 3 77 8 32 September 14 1972 29 $ 322 44 1 55 4 90 October 14 2018 05 $ 305 46 2 32 5 27 November 14 2067 56 $ 338 64 2 45 10 86 December 14 2058 9 $ 310 35 0 42 8 35 January 15 1994 99 $ 354 53 3 10 14 24 a (2 points) Use scatter plot to graph the returns of Amazon com stock against the returns of the S P 500, and add a trend line in this graph b (1 point) What is name of this trended line What is the Beta of Amazon c (1 point) Estimate the relation between Amazon return and SP500 return using linear regression model Go to the Data tab, Data Analysis, and select Regression, then OK Interpret your results

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 05, 2024

Price Data Date S&P 500 Amazon.com January-10 1073.87 $ 125.41 February-10 1104.49 $ 118.40 2.85% -5.59% March-10 1169.43 $ 135.77 5.88% 14.67% April-10 1186.69 $


Price Data

Date	S&P 500	Amazon.com
January-10	1073.87	$ 125.41
February-10	1104.49	$ 118.40	2.85%	-5.59%
March-10	1169.43	$ 135.77	5.88%	14.67%
April-10	1186.69	$ 137.10	1.48%	0.98%
May-10	1089.41	$ 125.46	-8.20%	-8.49%
June-10	1030.71	$ 109.26	-5.39%	-12.91%
July-10	1101.6	$ 117.89	6.88%	7.90%
August-10	1049.33	$ 124.83	-4.74%	5.89%
September-10	1141.2	$ 157.06	8.76%	25.82%
October-10	1183.26	$ 165.23	3.69%	5.20%
November-10	1180.55	$ 175.40	-0.23%	6.16%
December-10	1257.64	$ 180.00	6.53%	2.62%
January-11	1286.12	$ 169.64	2.26%	-5.76%
February-11	1327.22	$ 173.29	3.20%	2.15%
March-11	1325.83	$ 180.13	-0.10%	3.95%
April-11	1363.61	$ 195.81	2.85%	8.70%
May-11	1345.2	$ 196.69	-1.35%	0.45%
June-11	1320.64	$ 204.49	-1.83%	3.97%
July-11	1292.28	$ 222.52	-2.15%	8.82%
August-11	1218.89	$ 215.23	-5.68%	-3.28%
September-11	1131.42	$ 216.23	-7.18%	0.46%
October-11	1253.3	$ 213.51	10.77%	-1.26%
November-11	1246.96	$ 192.29	-0.51%	-9.94%
December-11	1257.6	$ 173.10	0.85%	-9.98%
January-12	1312.41	$ 194.44	4.36%	12.33%
February-12	1365.68	$ 179.69	4.06%	-7.59%
March-12	1408.47	$ 202.51	3.13%	12.70%
April-12	1397.91	$ 231.90	-0.75%	14.51%
May-12	1310.33	$ 212.91	-6.27%	-8.19%
June-12	1362.16	$ 228.35	3.96%	7.25%
July-12	1379.32	$ 233.30	1.26%	2.17%
August-12	1406.58	$ 248.27	1.98%	6.42%
September-12	1440.67	$ 254.32	2.42%	2.44%
October-12	1412.16	$ 232.89	-1.98%	-8.43%
November-12	1416.18	$ 252.05	0.28%	8.23%
December-12	1426.19	$ 250.87	0.71%	-0.47%
January-13	1498.11	$ 265.50	5.04%	5.83%
February-13	1514.68	$ 264.27	1.11%	-0.46%
March-13	1569.19	$ 266.49	3.60%	0.84%
April-13	1597.57	$ 253.81	1.81%	-4.76%
May-13	1630.74	$ 269.20	2.08%	6.06%
June-13	1606.28	$ 277.69	-1.50%	3.15%
July-13	1685.73	$ 301.22	4.95%	8.47%
August-13	1632.97	$ 280.98	-3.13%	-6.72%
September-13	1681.55	$ 312.64	2.97%	11.27%
October-13	1756.54	$ 364.03	4.46%	16.44%
November-13	1805.81	$ 393.62	2.80%	8.13%
December-13	1848.36	$ 398.79	2.36%	1.31%
January-14	1782.59	$ 358.69	-3.56%	-10.06%
February-14	1859.45	$ 362.10	4.31%	0.95%
March-14	1872.34	$ 336.37	0.69%	-7.11%
April-14	1883.95	$ 304.13	0.62%	-9.58%
May-14	1923.57	$ 312.55	2.10%	2.77%
June-14	1960.23	$ 324.78	1.91%	3.91%
July-14	1930.67	$ 312.99	-1.51%	-3.63%
August-14	2003.37	$ 339.04	3.77%	8.32%
September-14	1972.29	$ 322.44	-1.55%	-4.90%
October-14	2018.05	$ 305.46	2.32%	-5.27%
November-14	2067.56	$ 338.64	2.45%	10.86%
December-14	2058.9	$ 310.35	-0.42%	-8.35%
January-15	1994.99	$ 354.53	-3.10%	14.24%

a. (2 points) Use scatter plot to graph the returns of Amazon.com stock against the returns of the S&P 500, and add a trend line in this graph. b. (1 point) What is name of this trended line? What is the Beta of Amazon? c. (1 point) Estimate the relation between Amazon return and SP500 return using linear regression model. Go to the Data tab, Data Analysis, and select Regression, then OK. Interpret your results.