Please use the individual asset and portfolio expected return and variance example $($see slides $4-14$ from chapter $11)$ that we went through in the video and work through the following questions. Upload your excel file here. Please use all the cell reference and functions to do all the calculations inside the excel.

Consider the following two risky asset world. The only assets are a stock fund and a bond fund. Please calculate stock and bond expected returns, standard deviations, and correlation coefficient for stock and bond.

If you put $\frac{1}{3}$ of your money in this stock and the rest in the bond, please calculate your portfolio's expected return and standard deviation.

$\backslash$table$[[$Scenario$,$Probability,Stock return,Bond return$],[$Recession$,\mathrm{.}25,-7\%,17\%$