You face two investment opportunities with the following projected returns

$\backslash$table$[[\backslash$table$[[$State of$],[$Economy$]],\backslash$table$[[$Probability of State$],[$of Economy$]],\backslash$table$[[$Investment A$],[$Return $(\%)]],\backslash$table$[[$Investment B$],[$Return $(\%)]]],[$Recession$,\mathrm{.}3,-10,5],[$Normal$,\mathrm{.}6,15,10],[$Boom$,\mathrm{.}1,30,15]]$

Use Excel to answer the following questions:

a$)$ For each investment, calculate the expected return and standard deviation.

b$)$ Calculate the covariance and correlation between the projects.

c$)$ Form a portfolio with $20\%$ of your wealth in asset A and $80\%$ of your wealth in asset

B$.$ What will be the expected value and standard deviation of your portfolio?

$($HINT: YOU CAN FIND EXAMPLES OF THESE CALCULATIONS IN THE NOTES$)$