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 (Use cells A6 to D9 from the given information to complete this question.) Output area: StockA Probability Return Product Return deviation Squared deviation Product Recession' 0.15 0' 0.04 0' 0.0060 0' V ' Normal, 0.55 0' 0.09 0' 0.0495 0' ' ' Boom' 0.30 0' 0.17 0' 0.0510 0' ' E(R) 0.1065 0 Variance Standard deviation Stock 3 Probability Return Product Return deviation Squared deviation Product Recession ' 0.15 0' (0.17}0'(0.0255)0' ' ' Normal ' 0.55 0' 0.12 0' 0.0660 0' ' ' Boom ' 0.30 0' 0.27 0' 0.0310 0' ' ' 7 E(R) 0.1215 0 Variance Standard Deviation