Please complete using Microsoft excel Please complete using Microsoft Excel

41) Your portfolio is invested 30 percent each in stocks A and C, and 40 percent in 41) stock B. What is the standard deviation of your portfolio given the following information? Probability of State Rate of Return if State Occu State of Economy of Economy Stock A Stock B Stock . Boom 0.25 0.25 0.25 0.45 Good 0.25 0.10 0.13 0.11 Poor 0.25 0.03 0.05 0.05 Bust 0.25 -0.04 -0.09 -0.09 SHOW ALL YOUR WORK INCLUDING EXPECTED RETURNS, VARIANCES, 8: STANDARD DEVIATIONS FOR INDIVIDUAL 81: PORTFOLIO AS REQUIRED