PLEASE PROVIDE EXCEL FORMULA

20 p0 ints eBook Hint Print References Consider the following information: Rate of Return If State Occurs State of Probability of Economy 55:33:, Stock A Stock B Stock C Boom .15 .38 .48 .28 Good .45 .22 .19 .15 Poor .30 .04 .09 .06 Bust .10 .16 .34 .11 a. Your portfolio is invested 24 percent each in A and C, and 52 percent in B. What is the expected return of the portfolio? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b-'I. What is the variance of this portfolio? (Do not round intermediate calculations and round your answer to 5 decimal places, e.g., .32161.) b-2. What is the standard deviation? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) u_l all El_I