Information is provided for the common stock of company X$,$ an efficient portfolio Q$,$ the market portfolio

M$,$ and the risk$-$free asset.

Expected Return Beta Standard Deviation

Stock X $2\mathrm{.}048\%$

Efficient Portfolio Q $12\%1\mathrm{.}4$

Market Portfolio M $10\%20\%$

Risk$-$free Asset

a$.$ Fill in the six missing values in the table above. Show your work.

b$.$ Is the correlation between stock X and the market portfolio M smaller than, equal to$,$ or greater than

the correlation between efficient portfolio Q and the market portfolio M$?$ Explain. Calculations using excel formuls