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.

NYSE

Average return, $\frac{?}{\text{b}\text{a}\text{r}}(r{)}_{\text{A}\text{v}\text{g}}$

Standard deviation, $$

Stock X

$\%$

$\%$

$\%$

$\%$