Suppose the returns on long term government bonds are normally distributed Assume long term government bonds have a mean return of 6 1 percent and a standard deviation of 9 8 percent Requirement 1 What is the probability that your return on these bonds will be less than 3 7 percent in a given year Use the NORMDIST function in Excel to answer this question ( Do not round intermediate calculations Enter your answer as a percentage r ounded to 2 decimal places (e g , 32 16) ) Requirement 2 What range of returns would you expect to see 95 percent of the time ( Negative amount should be indicated by a minus sign Input your answers from lowest to h ighest to receive credit for your answers Do not round intermediate calculations Enter your answers as a percentage r ounded to 2 decimal places (e g , 32 16) ) Requirement 3 What range would you expect to see 99 percent of the time ( Negative amount should be indicated by a minus sign Input your answers from lowest to highest to receive credit for your answers Do not round intermediate calculations Enter your answers as a percentage r ounded to 2 decimal places (e g , 32 16) )

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 23, 2024

Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a mean return of 6.1 percent and a standard deviation

Suppose the returns on long-term government bonds are normally distributed. Assume long-term government bonds have a mean return of 6.1 percent and a standard deviation of 9.8 percent.

Requirement 1:

What is the probability that your return on these bonds will be less than 3.7 percent in a given year? Use the NORMDIST function in Excel to answer this question. (Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (e.g., 32.16).)

Requirement 2:
What range of returns would you expect to see 95 percent of the time? (Negative amount should be indicated by a minus sign. Input your answers from lowest to highest to receive credit for your answers. Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).)

Requirement 3:
What range would you expect to see 99 percent of the time? (Negative amount should be indicated by a minus sign. Input your answers from lowest to highest to receive credit for your answers. Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).)