please check my work and solve for variance and standard deviation

Spreadsheet 5.1 Scenario analysis for a stock index fund Scenario Probability Holding period return (%) Column B x Column C Deviation from mean return Squared deviation from mean return Column B x Column F 1. Severe recession 0.05 -37 -1.85 4.4 18.9 0.95 2. Mild recession 0.25 -11 -2.75 2.8 7.6 1.89 3. Normal growth 0.40 14 5.60 -5.6 31.4 12.54 4. Boom 0.30 30 9.00 -9.0 81.0 24.30 Column sums: Mean return: 2.50 Variance: Standard deviation:

Spreadsheet 5.1 Scenario analysis for a stock index fund Spreadsheet 5.1 Scenario analysis for a stock index fund