The data has been collected in the Microsoft frcel Online file below. Open the spreadsheet and perform the recquired analysis to answer the questions helow. Open krreadsheet. a. Use a spreadstiest (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. theta= b. Determune 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. equal their past values). Also assume that Stock X es in equibinim - that is, it plots on the Security Market tine. What is the ink free rate? Do not round mitrinediate calculations, Round poar answer to two decimal places. d. Plot the Senurity Market tine: Select the correct graph. The conrect graph is B. e. Suppose you hold a large, well-diversified portfolio and are considering adding to that portfolio either 5 tock X or another stock, 5 tock Y, which has the same beta as Stock X but a higher standard deviation of returns. Stocks X and Y have the same expected returns: rX - ro y=10.6 Sis . Which stock shisuld you choose