Comprehensive Problem Assignment \#3 4 You are given the following information concerning a stock and the market: 15 points a. Calculate the average return and standard deviation for the market and the stock. Note: Use Excel to complete the problem. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. b. Calculate the correlation between the stock and the market, as well as the stock's beta. Note: 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