Suppose the returns on an asset are normally distributed. The historical average annual return for the asset was $5\mathrm{.}2$ percent and the standard deviation was $10\mathrm{.}6$ percent.

What is the probability that your return on this asset will be less than $9\mathrm{.}7$ percent in a given year? Use the NORMDIST function in Excel$$ to answer this question.

Note: Do not round intermediate calculations and enter your answer as a percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.$

What range of returns would you expect to see $95$ percent of the time?

Note: Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.$

What range of returns would you expect to see $99$ percent of the time?

Note: Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.$Suppose the returns on an asset are normally distributed. The historical average annual return for the asset was $5\mathrm{.}2$ percent and the

standard deviation was $10\mathrm{.}6$ percent.

a$.$ What is the probability that your return on this asset will be less than $-9\mathrm{.}7$ percent in a given year? Use the NORMDIST function

in Excel ${?}^{}$ to answer this question.

Note: Do not round intermediate calculations and enter your answer as a percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.$

b$.$ What range of returns would you expect to see $95$ percent of the time?

Note: Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do

not round intermediate calculations and enter your answers as a percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.$

c$.$ What range of returns would you expect to see $99$ percent of the time?

Note: Enter your answers for the range from lowest to highest. A negative answer should be indicated by a minus sign. Do

not round intermediate calculations and enter your answers as a percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.$