Question: in excel formulas please B D E F G H Based on the following information, calculate the expected return and standard deviation for Stock A
B D E F G H Based on the following information, calculate the expected return and standard deviation for Stock A and Stock B. input area: State Probability Stock A Stock B Recession 0.15 0.04 (0.17) Normal 0.55 0.09 0.12 Boom 0.30 0.17 0.27 10 11 (Use cells A6 to D9 from the given information to complete this question.) BROR ER NOW Return Product Return deviation Squared deviation 13 Output ored 14 15 16 17 18 Product Stock A Probability Recession Normal Boom F E(R) Variance Probability Return Product Return deviation Squared deviation Product F 20 Standard deviation 21 Stock B 22 Recession 23 Norma 24 Boom 25 20 Standard deviation F F EUR) Variance
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
