You are given the following set of data: Year 1 NM & S7 2 3 4 5 6 HISTORICAL RATES OF RETURN Stock X NYSE - 26.5% 37.2 23.8 - 7.2 6.6 20.5 30.6 Beta = - 18.0% 19.0 18.0 2.0 8.4 19.0 19.9 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. 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 calculations. Round your answer to two decimal places. 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.

You are given the following set of data: The data has been coliected in the Microsoft Excel Online file beiow. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadshect a. Use a spreaosheet (or a calculator with a tinear regression function) to determine Stock X's beta coefficient, Do not round intermediate calculatians. Found your answer to two decimal places. Beta - b. Deterimine the arithmetic average rates of return for Stock X and the NrSE over the penod given, Calculate thet standand deviationis of returns for both Stock X and the fWrsE, Do not rourd intertnediate calculations. Round your answers to two decmal phaces. a. Use a spreadsheet (or a calculator whth a linear regrestion function) to determine Stock X's beta coefficient, Do not round intermediate calculations. found your answer to two decimal places. Beta= b. Detemine the arithmetic average rates of retum for Stock X and the NrSE over the period given. Caiculate the standard deviations of refurns for both stock X and the NYSE. Do not round intermediate calculations. Rlound your answers to two decimas places. C. Astume that the stuation during Years 1 to 7 is expected to prevail in the future (li.e. Secunty Markent Lne. What is the fisk. free ratef Do not round intermediate cakculations, Round vour answer to two decimat olaces q. Pos the Security Market une. Splect the carrect graph