Consider the following information. your portfolio is invested 30 percent each in A and C...

please include excel formulas. thank you!

File Home Insert Draw Formulas Data Review View Help Editing Calibri 10 BA General B22 D E F G H McGraw Hill Consider the following information. Your portfolio is invested 30 percent each In A and Cand 40 percent in B. What is the expected return of the portfolio? What is the variance of this portfolio? The standard deviation? 2 ON Your timed assic stil counting do much time you click on your or assignment tab. 4 Input area: 5 6 State Probability Stock A Stock B 7 Boom 0.15 0.35 0.40 8 Good 0.45 0.16 0.17 9 Poor 0.30 (0.01) (0.03) 10 Bust 0.10 (0.10) (0.12) 11 weights 0.30 0.40 12 13 (Use cells A6 to E11 from the given information to complete this question) 14 15 Output area: 16 Stock 0.28 0.09 0.01 (0.09) 0.30 Check Answers 60 Check My Work Legend Graded cell: Lean Save and Retu Excel Marrow Hill Byce Question som Search Option + File Home Insert Draw Formulas Data Review View Help Editing Calibri 11 B A... General B22 E F G H McGraw Hill A C D 12 13 (Use cells A5 to E11 from the given information to complete this question 14 15 Output area: Your timed assignme still counting down. much time you have click on your origina assignment tab Product Return deviation Squared deviation Product 0515 11 Check Answerst 999988 17 Stock A Probability Portfolio return 18 Boom 19 Good 0.45 20 Poor 0.30 21 Bust 0.10 22 E(R) Standard deviation 24 Variance Check My Work Legend Graded celt Leave hl 26 ndo any additional work you need to solve this question or can be used to show your work