Assume that the returns from an asset are normally distributed. The average annual return for this asset over a specific period was 16.8 percent and the standard deviation of the asset was 42.30 percent. Use the NORMDIST function in Excel® to answer this question.
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.)
What is the probability of the asset tripling in value? (Do not round intermediate calculations and enter your answer as a percent rounded to 6 decimal places, e.g., 32.161616.)
Get Answers For Free
Most questions answered within 1 hours.