answer part c please, the risk free rate? 4.07 is showing as wrong.

Deow. X Open spreadsheet a. Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient. Do not round Intermediate calculation Round your answer to two decimal places. Beta = 0.57 b. Determine the arithmetic average rates of return for Stock X and the NYSE over the period given. Calculate the standard deviations of returns for both Stock X and the NYSE. Do not round intermediate calculations, Round your answers to two decimal places. NYSE Stock X 8.67 % Average return, Ang 12.14 % Standard deviation, o 22.63 % 14.63 % c. Assume that the situation during Years 1 to 7 is expected to prevail in the future clef x = x, Atrage F = FM Acurager and both o, and by in the future will equal their past values). Also assume that Stock X is in equilibrium that is it plots on the Security Market Line. What is the risk-free rate? Do not round intermediate calculations. Round your answer to two decimal places 4,07 % d. Plot the Security Market une Select the correct graphi The correct graph is graph vo 2 Security Marie Autosaved at 9:33 AM Next Video Excel Online Structured Activity: Characteristic Line and Security Market Line You are given the following set of data: HISTORICAL RATES OF RETURN Year NYSE Stock X 1 - 26.5% 23.0% 37.2 16.0 | 23.8 13.5 4 - 7.2 6.0 5 6.6 11.4 6 20.5 19.0 7 30.6 17.8 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the requ below. 01011 Open spreadsheet a. Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient. Round your answer to two decimal places. Beta 0.52 b. Determine the arithmetic average rates of return for Stock X and the NYSE over the period given. Calculate the both Stock X and the NYSE. Do not round intermediate calculations. Round your answers to two decimal places. Autosaved at 9:33 AM