Use excel to answer the following (highlight your answer for the standard deviation).

Scenario Recession Normal Boom Probability 0.333333333 0.333333333 0.333333333 Rate of Return% Auto Stock Gold Stock Portfolio Return -8 20 5 3 18 -20 expected return variance standard deviation portfolio return = (0.75 x auto stock return) + (0.25 x gold stock return)