Video Excel Online Structured Activity: Expected Returns: Discrete Distribution The market and Stock ) have the following probability distributions: Probability 0.3 14.00 % 21.00 % 0.4 8.00 3.00 0.3 20.00 12.00 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. ppen spreadsheet ity: Expected Returns: Discrete Distribution ppen spreadsheet a. Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two decimal places % Calculate the expected rate of return for Stock ). Do not round intermediate calculations. Round your answer to two decimal places % b. Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal places. % Calculate the standard deviation for Stock J. Do not round intermediate calculations. Round your answer to two decimal places. % B10 D E 1 Expected Returns: Discrete Distribution 2 3 Probability Distributions: 4 Probability 5 0.3 14.00% 21.00% 6 0.4 8.00% 3.00% 7 0.3 20.00% 12.00% 8 9 10 Expected return 11 12 Standard deviation 13 14 15 16 17 Formulas WNA WNA WNIA NA Sheet1