compute the expected return and standard deviation of the returns on a portfolio that is invested in stocks A, B, and C? The total amount you invested in the portfolio is $95,000, where $33,000 of this amount of money is invested in stock A and $20,000 is invested in stock B, the rest were invested in stock C.

State of Economy Probability of state of Economy Return if state Occurs

Stock A. Stock B Stock C

Boom 10% 17% 6% 22%

Normal 35% 8% 10% 15%

Recession 55% -3% 12% -19%

Notes:

You must show all steps in finding the Standard Deviation.

Compute in Excel.