PLEASE ANSWER USING EXCEL. PLEASE DO NOT USE CHATGPT OR OTHER AI TECHNOLOGY TO ANSWER.$($Portfolio of two stocks$)$ The following spreadsheet presents data for stocks A and $B.$

$\backslash$table$[[,$A$,$B$,C($Portfolio of two stocks$)$ The following spreadsheet presents data for stocks A and B$.$

$1$

$2345678$

AB C RETURN STATISTICS OF STOCKS A AND B Stock A

Average return Variance

Standard deviation

Covariance of return, Cov$($rA$,$rB$)$ Correlation of return

$15\%0\mathrm{.}12$

B$7/($B$5*$C$5)$

a$.$ What are the return and the standard deviation of a portfolio com$-$posed of $30\%$ of stock A and $70\%$ of stock B$?$

b$.$ What are the return and the standard deviation of an equally weighted portfolio of stocks A and B$?$