Excel Activity: Evaluating Risk and Return values, if any. X Download spreadsheet Evaluating_Risk and Return-93650e.xlsx Also, you cannot calculate the rate of return for 2015 because you do not have 2014 data.) Round your answers to two decimal places. two decimal places. Bartman Industries Reynolds Inc. Winslow 5000 Standard deviation % % % c. Calculate the coefficients of variation for Bartman, Reynolds, and the Winslow 5000. Round your answers to two decimal places. Bartman Industries Reynolds Inc. Winslow 5000 Coefficient of variation Bartman Industries Reynolds Inc. Winslow 5000 Sharpe ratio e. Construct a scatter diagram that shows Bartman's and Reynolds's returns on the vertical axis and the Winslow 5000 Index's returns on the horizontal axis. Choose the correct graph. The correct graph is Stocks' Returns vs. Index's Returns A. B. f. Estimate Bartman's and Reynolds's betas by running regressions of their returns against the index's returns. Round your answers to four decimal places. Bartman's beta: Reynolds's beta: Are these betas consistent with your graph? These betas consistent with the scatter diagrams. expected return on the market. Use the SML equation to calculate the two companies' required returns. Round your answers to two decimal places. Bartman's required return: % Reynolds's required return: % required return to two decimal places. Portfolio's beta: Portfolio's required return: % required return if it consists of 20% of Bartman, 10% of Stock A, 55% of Stock B, and 15% of Stock C. Round your answer to two decimal places. %