3. Monthly excess return data are presented below for each of three stocks and the S&P index (corrected for dividends) for a 12-month period.

Month	A	B	C	S&P
1	12.05	25.2	31.67	12.28
2	15.27	2.86	15.82	5.99
3	-4.12	5.45	10.58	2.41
4	1.57	4.56	-14.43	4.48
5	3.16	3.72	31.98	4.41
6	-2.79	10.79	-0.72	4.43
7	-8.97	5.38	-19.64	-6.77
8	-1.18	-2.97	-10	-2.11
9	1.07	1.52	-11.51	3.46
10	12.75	10.75	5.63	6.16
11	7.48	3.79	-4.67	2.47
12	-0.94	1.32	7.94	-1.15

Calculate the following quantities: (show all works) a. Alpha for each stock b. Beta for each stock c. The standard deviation of the residuals from each regression d. The correlation coefficient between each security and the market e. The average return on the market f. The variance of the market

4. Using the same data in Q3,(show all works) a. Compute the mean return and variance of return for each stock using (i) The single-index model (ii) The historical data

b. Compute the covariance between each possible pair of stocks using (i) The single-index model (ii) The historical data

c. Compute the return and standard deviation of a portfolio constructed by placing one-third of your funds in each stock, using (i) The single-index model (ii) The historical data

d. Explain why the answers to parts a.(i) and a.(2) are the same, while the answers to parts b.(i), b.(ii) and c.(i) and c.(ii) are different.