Problem 11.1: Please layout your calculation of this problem in the excel file that needs to be submitted on Connect.
Based on the following information:
able[[ able[[State of],[Economy]], able[[Probability of],[State of],[Economy]], able[[Return on],[Stock J]], able[[Return on],[Stock K]]],[Bear,.26,-.021,.033],[Normal,.61,.137,.061],[Bull,.13,.217,.091]]
a. Calculate the expected return for each of the stocks. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)
b. Calculate the standard deviation for each of the stocks. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)
c. What is the covariance between the returns of the two stocks? (Do not round intermediate calculations and round your answer to 6 decimal places, e.g., .161616.)
d. What is the correlation between the returns of the two stocks? (Do not round intermediate calculations and round your answer to 4 decimal places, e.g., .1616.)
Please lay out inital input of the problems and your calculations of expected returns, standard deviation for each stock and covariance and correlation betwen the returns of these two stocks in the excel file. (Excel part: 10 points)
Problem 11.1: Please layout your calculation of this problem in the excel file that needs to be submitted on Connect Based on the following information: State of Probability of State of Return on Return on Economy Economy Stock J Stock K Bear .26 .021 .033 Normal .61 .137 .061 Bull .13 .217 .091
a.Calculate the expected return for each of the stocks.(Do not round intermediate
32.16.) b.Calculate the standard deviation for each of the stocks.(Do not round intermediate
32.16.)
c.What is the covariance between the returns of the two stocks? (Do not round intermediate calculations and round your answer to 6 decimal places,e.g.,.161616.) d.What is the correlation between the returns of the two stocks?(Do not round intermediate calculations and round your answer to 4 decimal places,e.g.,.1616. Please lay out inital input of the problems and your calculations of expected returns,standard deviation for each stock and covariance and correlation betwen the returns of these two stocks in the excel file.(Excel part:10 points)
Istock