Question: Suppose the average return on Asset A is 6.6 percent and the standard deviation is 7.8 percent and the average return and standard deviation on
Suppose the average return on Asset A is 6.6 percent and the standard deviation is 7.8 percent and the average return and standard deviation on Asset B are 3.7 percent and 3.2 percent, respectively. Further assume that the returns are normally distributed. Use the NORMDIST function in Excel to answer the following questions..
| a) What is the probability that in any given year, the return on Asset A will be greater than 9 percent? Less than 0 percent? b)What is the probability that in any given year, the return on Asset B will be greater than 9 percent? Less than 0 percent?
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
