Problem $10-28$ Using Probability DistributionsSuppose the average return on Asset A is $6\mathrm{.}4$ percent and the

standard deviation is $8\mathrm{.}4$ percent and the average return and

standard deviation on Asset B are $3\mathrm{.}6$ percent and $3\mathrm{.}0$ percent,

respectively. Further assume that the returns are normally

distributed. Use the NORMDIST function in Excel$$ to answer the

following questions.$$

$$What is the probability that in any given year, the return on

Assets A will be greater than $10$ percent? Less than $0$

percent?$($Do not round intermediate calculations and

round your answers to $2$ decimal places. $($e$.$g$.,32\mathrm{.}16))$

$$

$$What is the probability that in any given year, the return on

Asset B will be greater than $10$ percent? Less than $0$

percent?$($Do not round intermediate calculations and

round your answers to $2$ decimal places. $($e$.$g$.,32\mathrm{.}16))$

$$

$$In a particular year, the return on Asset A was $4\mathrm{.}23$ percent.

How likely is it that such a low return will recur at some point in

the future?$($Do not round intermediate calculations

and round your answers to $2$ decimal places. $($e$.$g$.,$

$32\mathrm{.}16))$

$$

$$Asset B had a return of $9\mathrm{.}40$ percent in this same year. How

likely is it that such a high return on Asset B will recur at some

point in the future?$($Do not round intermediate

calculations and round your answers to $2$ decimal places. $($e$.$g$.,$

$32\mathrm{.}16))$

$$