You are provided the following information on the two stocks: USE EXCEL TO SHOW FORMULAS AND CALCULATIONS

$1.-$Calculate: expected return, Standard deviation and Beta for each stock

$2.-$Which stocks has more systematick risk and which one has more unsystematic risk? Which stock is riskier? Explain your answer$\backslash$table$[[$State$,$Probability,Stock I,Stock II$],[$Recession$,15\mathrm{.}00\%,5\mathrm{.}00\%,-21\mathrm{.}00\%$