MUST BE DONE IN EXCEL

Chapter 12, where you will find a spreadsheet containing 5 years of monthly rates of return on Dell Computer (DELL), Consolidated Edison (ED), and the S&P 500. a. Calculate the beta of each firm. Use Excels SLOPE function, which fits a regression line through a scatter diagram of two series of numbers. b. Does the relative magnitude of each beta make sense in terms of the business risk of the two firms? Explain.

MUST BE DONE IN EXCEL

Date	S&P	U.S. Steel	Hershey
4/1/13	-0.45	-4.04	-0.58
3/1/13	3.60	-6.40	5.03
2/1/13	1.11	-6.57	5.44
1/2/13	5.04	-6.28	10.01
12/3/12	0.71	10.62	-1.43
11/1/12	0.28	6.03	7.04
10/1/12	-1.98	6.92	-2.88
9/4/12	2.42	-1.98	-1.29
8/1/12	1.98	-5.62	0.64
7/2/12	1.26	0.25	-0.41
6/1/12	3.96	1.50	7.72
5/1/12	-6.27	-28.21	0.35
4/2/12	-0.75	-3.54	9.26
3/1/12	3.13	7.90	1.04
2/1/12	4.06	-9.71	0.00
1/3/12	4.36	14.08	-1.13
12/1/11	0.85	-3.07	7.11
11/1/11	-0.51	7.87	1.40
10/3/11	10.77	15.20	-3.39
9/1/11	-7.18	-26.90	1.00
8/1/11	-5.68	-24.59	4.56
7/1/11	-2.15	-13.13	-0.72
6/1/11	-1.83	-0.16	2.00
5/2/11	-1.35	-3.25	-2.84
4/1/11	2.85	-11.56	6.20
3/1/11	-0.10	-6.17	3.88
2/1/11	3.20	-0.23	12.81
1/3/11	2.26	-1.28	-0.97
12/1/10	6.53	20.19	0.74
11/1/10	-0.23	13.90	-4.78
10/1/10	3.69	-2.55	3.98
9/1/10	8.76	3.17	2.40
8/2/10	-4.74	-4.04	-0.45
7/1/10	6.88	14.99	-1.95
6/1/10	-5.39	-18.34	2.43
5/3/10	-8.20	-13.54	0.24
4/1/10	1.48	-13.95	9.83
3/1/10	5.88	19.99	7.65
2/1/10	2.85	19.28	10.04
1/4/10	-3.70	-19.39	1.78
12/1/09	1.78	23.42	1.20
11/2/09	5.74	29.65	-5.67
10/1/09	-1.98	-22.26	-2.73
9/1/09	3.57	1.34	-0.95
8/3/09	3.36	10.27	-1.05
7/1/09	7.41	11.22	10.95
6/1/09	0.02	4.85	2.23
5/1/09	5.31	28.57	-1.74
4/1/09	9.39	25.66	4.02
3/2/09	8.54	7.42	3.13
2/2/09	-10.99	-33.92	-8.84
1/2/09	-8.57	-19.25	7.32
12/1/08	0.78	22.36	-3.50
11/3/08	-7.48	-16.80	-2.44
10/1/08	-16.94	-52.48	-5.81
9/2/08	-9.08	-41.68	9.53
8/1/08	1.22	-16.84	-1.06
7/1/08	-0.99	-13.21	12.16
6/2/08	-8.60	6.99	-16.35
5/1/08	1.07	12.34	5.68