You are given the following set of data: Historical patre ae netinan The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. 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 calculations. Round your answer to two decimal places. Beta= 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 calcutations. Round your answers to two decimal places. future will equal their past values). Also assume that Stock X is in equifibrium - that is, it plots on the Security Market Une. What is the risk-free rate? Do not round intermediate calcilations. Round your answer to two decimal places. d. Plot the Security Market Line. Select the correct graph. The correct graph is B. F. e. Suppose you hold a targe, well-diversified portfolio and are considering adding to that portfolio either Stock X or another stock, stock Y, which has the same beta as Stock X but a higher standard deviation of retums. Stocks X and Y haye the same expected returns: Fx= r Y. 10.646. Which stock should you choose? Data points for SML plot: HN/A HN/A Calculation Mode Automatic Workbook Statistics Excel template - Saved Security Market Line Bheet1+ Calculution Mode Automatic Warkbook Stetistics