Q Search activity. Characteristic Line and Security Market Line You are given the following set of data: HISTORICAL RATES OF RETURN Year NYSE Stock X 1 - 23.0% - 26.5% 37.2 2 16.0 3 23.8 13.5 6.0 4 - 7.2 5 6.6 11.4 6 20.5 19.0 17.8 7 30.6 The data has been collected in the picrosoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet 2. 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 - b. Determine the arithmetic average rates of return for Stock X and the wyse over the period given. Calculate the standard deviations of returns for both stock and the NYSE. Do not round intermediate calculations. Round your answers to two decimal places NYSE Stock X M Average return. Standard deviation