. 10.00 points Problem 13-7 Calculating Returns and Standard Deviations Caloulate the expected return and standard deviation for the two stocks. Calculating Retums and Standard Deviations-Exce HOME INSERT PAGE LAYOUT FORMULAS D OATA REVIEW VIEW Sign In | M A-Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Clipboard F18 Based on the following information, calculate the expected return and standard deviation for the two stocks Complete the following analysis. Do not hard code values in your calculations. Return Squared Stock A Probability Return Product Deviation Deviation Product 0.05 0.08 0.13 Recession 0.20 Normal 0.55 10 ER) Variance 12 13 Standard Deviation 2 4 5 Calculating Returns and Standard Deviations Exce HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In ,IA'. A. || |% 12 A-Alignment Number Conditional Format as ell Formatting Table Styles lipboard F18 A B C Based on the following information, calculate the expected return and standard deviation for the two stocks. 4Complete the following analysis. Do not hard code values in your calculations. Return Squared Stock A Probability Return Product Deviation Deviation Product 0.05 0.08 0.13 Recession 0.20 Normal 0.55 10 Variance 12 Standard Deviation 14 Return Squared 16 Stock B Probability Return Product DeviationDeviation Product (0.17) 0.12 0.29 E(R) - Recession 0.20 Normal0.55 Boom 0.25 Variance 4 O W ERTYU