Question: Monthly excess return data are presented below for each of three stocks and the S&P index ( corrected for dividends ) for a 1 2

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.
\table[[,Security],[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:
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
 Monthly excess return data are presented below for each of three

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!