Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient Do not round intermediate calculationsRound your answer to two decimal places

You are given the following set of data: The data has been collected in the Microsolt Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Dben spreadsheet a. Use a spreadsheet for a calculator with a linear regression function) to determine Stock X's beta coefficient. Do not round intermediate calculations. Round yo answer to two decimal places. Betax= b. Determine the anthmetic average rates of return for 5 tock X and the NYSE over the period given. Colculate the standard devations of returns for hoth Stock X and the Nrse. Do not round intermediate calculations. Round vour answers to twe deciral olaces. 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: 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 found intermediate calculations. Round your answer to two decimal places. d. Pot the Security Market Line. Select the correct graph. The correct graph is B. C. D. e. Suppose you hold a large, weil-diversufied portfolio and are considering adding to that portfolo either Stock or anceher stock, Stock y, which has the came beta as 5tock X but a higher standard deviation of returns. 5 tocks x and y have the same expected returns: rx=ry=10.60. . Which stock should you choose