1.Calculate the average return and standard deviation for the market and the stock.(Use excel to complete the problem. Round your answer to 2 decimal place. Omit the "%" sign in your response.)

2.Calculate the correlation between the stock and the market, as well as the stock's beta.(Use excel to complete the problem.Round your correlationanswer to 2 decimal places and Beta answer to 4 decimal places.)

You are given the following information concerning a stock and the market: Returns Year Market Stock 2005 19% 31% 2006 1 0 1 6 2007 1 9 3 2008 -1 5 -28 2009 37 1 6 201 0 1 5 1 5 1. Calculate the average return and standard deviation for the market and the stock. (Use excel to complete the problem. Round your answer to 2 decimal place. Omit the "%" sign in your response.) Market Stock Average return % \"/9 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. Round your correlation answer to 2 decimal places and Beta answer to 4 decimal places.) Correlation Beta