The market and Stock have the following probability distributions: Probability Гм ry 0.3 14.00 % 19.00 % 0.4 9.00 6.00 0.3 17.00 13.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. X Open 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 J. Do not round intermediate calculations. Round your answer to two decimal places. % b. Calculate the standard deviation for the market. Do not round
ty: Expected Returns: Discrete Distribution below. X Open 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 J. 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. % Check My Work Reset Problem
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!