premium is $5\%.$ 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$.$ Calculate each stock's coefficient of variation. Round your answers to two decimal places. Do not round intermediate calculations.

$C{V}_x=,33$

$C{V}_y=,3$

b$.$ Which stock is riskier for a diversified investor?

than Stock Y$.$

than Stock X$.$

c$.$ Calculate each stock's required rate of return. Round your answers to two decimal places.

$r_x=,\%$

$r_y=,12\mathrm{.}5\%$

d$.$ On the basis of the two stocks' expected and required returns, which stock would be more attractive to a diversified investor?

$r_p=$

$\%$

f$.$ If the market risk premium increased to $6\%,$ which of the two stocks would have the larger increase in its required return?