Please show the Excel references.

L8 fx A B D E F G H | J K L M N O 1 Chapter 1 - Homework 1.25a - 1.25b (enter the excel formula to solve the problems) 2 Year Stock Price Dividends HPR (% Change) St Dev (R- AvgR)^2 3 4 1 $ 100.00 $ 3.50 5 2 $ 115.00 $ 4.10 6 7 8 9 10 11 3 $ 95.00 $ 4.10 14 $ 110.00 $ 4.10 5 $ 125.00 $ 4.60 6 $ 120.00 $ 5.00 7 $ 140.00 $ 5.20 Average= Total = (n-1)= Variances St Dev= Using Excel Formula to verify st Dev= 12 13 14 15 16 17 18 19 20 21 22 23 D18 X fx A B D E F G . j K L M 1 Chapter 1 - Homework 1.26a - 1.26b (enter the excel formula to solve the problems) 2 Economic Probability Rate of Scenario % Return % p. RoR (ROR- AvgROR)^2 p. (ROR- AvgROR )^3 3 4 25.00% -10.00% Recession Normal 5 50.00% 12.00% 6 Boom 25.00% 25.00% 100.00% Average= 7 Total Variance 8 St. Dev= 9 10 11 12 13 14 15 16 17 18 19 C18 A X fx A B D E F G H K L M N 1 Chapter 1 - Homework 1.27a - 1.27b (enter the excel formula to solve the problems) 2 3 Current Stock = $ 30.00 Average Average Economic Probability Stock Dividends Scenario % Price $ $ HPR% p. ROR (RoR- AvgROR)^2 p. (ROR- AvgROR) 3 4 5 Recession 20.00% $ 25.00 $ 1.00 09 Normal 50.00% $36.00 $ 2.40 7 Boom 30.00% $ 56.00 $ 3.00 8 Total 100.00% Average Variance 9 St. Dev= 10 11 12 13 14 15 16 17 18 19 20 21 22