Cannot figure out Portfolio Standard Deviation (the bottom blank of the document).

Home Insert Draw Page Layout Formulas Data Tell me Share U Comments Au Co % Conditional Formatting 8 Format as Table v Clipboard Font Alignment Number Cells Editing Ideas Sensiti Cell Styles V D B43 fx Portfolio Standard Deviation A B C E 18 19 3. Please Calculate Standard Deviation for Stock and Bond Funds 20 Funds Standard Deviation 21 Stock Fund 14.92% 14.92% 13.60% 22 Bond Fund 7.75% 7.75% 7.99% 23 24 4. Please Calculate Portfolio Expected Rate of Return. You invest $60,000 in stock fund and $40,000 in Bond fund 25 26 Funds $ Investments % Weight of Investment 27 Stock Fund $ 60,000.00 60% 60% 28 Bond Fund $ 40,000.00 40% 40% 29 $ 100,000.00 30 31 Portfolio Expected Rate of Return 8.40% 8.40% 32 33 5. Please Calculate Portfolio Standard Deviation using portfolio weights in #4 34 Let's Compute portfolio return each state 35 Stock Fund Bond Fund 36 Scenario Probability Rate of Return Rate of Return Portfolio Return 37 Recession 0.3 -0.11 0.16 -0.20% 38 Normal 0.4 0.13 0.06 10.20% 39 Boom 0.3 0.27 -0.04 14.60% 40 41 42 43 Portfolio Standard Deviation 5.9174% 44 45 46 47 48 49 50 51 52 52 Sheet1 Ready E u + 100%