Assume the returns from holding small-company stocks are normally distributed. Also assume the average annual return...

 

Transcribed Image Text:

Assume the returns from holding small-company stocks are normally distributed. Also assume the average annual return for holding the small-company stocks for a period of time was 16.5 percent and the standard deviation of those stocks for the period was 31.7 percent. Use the NORMDIST function in Excel® to answer the following questions. a. What is the approximate probability that your money will double in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 3 decimal places, e.g., 32.161.) b. What is the approximate probability that your money will triple in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 9 decimal places, e.g., 32.161616161.) Probability b. Probability a. % % Assume the returns from holding small-company stocks are normally distributed. Also assume the average annual return for holding the small-company stocks for a period of time was 16.5 percent and the standard deviation of those stocks for the period was 31.7 percent. Use the NORMDIST function in Excel® to answer the following questions. a. What is the approximate probability that your money will double in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 3 decimal places, e.g., 32.161.) b. What is the approximate probability that your money will triple in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 9 decimal places, e.g., 32.161616161.) Probability b. Probability a. % %

Answer rating: 100% (QA)

Given that And Average return standard deviation Approximate probabi... View the full answer