HISTORICAL RATES OF RETURN

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$\text{'}$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 calculations. Round your answers to two decimal places.