You are given the following information concerning a stock and the market: Retur
ID: 2765561 • Letter: Y
Question
You are given the following information concerning a stock and the market: Returns Year Market Stock 2008 15 % 27 % 2009 14 30 2010 15 6 2011 –14 –24 2012 37 16 2013 15 25 1. Calculate the average return and standard deviation for the market and the stock. (Use excel to complete the problem. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. Omit the "%" sign in your response.) Market Stock Average return % % Standard deviation % % 2. Calculate the correlation between the stock and the market, as well as the stock’s beta. (Use excel to complete the problem. Do not round intermediate calculations. Round your Correlation answer to 2 decimal places and Beta answer to 4 decimal places.) Correlation Beta
Explanation / Answer
The average return and std. deviation is as shown below:
The Beta and correction is as shown below:
Year Market Stock 2008 0.15 0.27 2009 0.14 0.3 2010 0.15 0.06 2011 -0.14 -0.24 2012 0.37 0.16 2013 0.15 0.25 Average return 12.64% 11.57% Std .dev 16.22% 20.27%Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.