Excel Online Structured Activity: CAPM, portfolio risk, and return correlation coefficients is between $0$ and $1.)$

$\backslash$table$[[$Stock$,$Expected Return,Standard Deviation,Beta$],[$A$,8\mathrm{.}76\%,14\%,0\mathrm{.}8],[$B$,10\mathrm{.}17,14,1\mathrm{.}1],[$C$,12\mathrm{.}52,14,1\mathrm{.}6]]$

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$.$ What is the market risk premium $(r_M-r_{RF})?$ Round your answer to two decimal places.

$\%$

b$.$ What is the beta of Fund P$?$ Do not round intermediate calculations. Round your answer to two decimal places.

c$.$ What is the required return of Fund P$?$ Do not round intermediate calculations. Round your answer to two decimal places. $\%$

d$.$ Would you expect the standard deviation of Fund $P$ to be less than $14\%,$ equal to $14\%,$ or greater than $14\%?$

I. less than $14\%$

II$.$ greater than $14\%$

III. equal to $14\%$