ZuoTi.Pro
Question

The historical returns on a balanced portfolio have had an average return of 8% and a...

The historical returns on a balanced portfolio have had an average return of 8% and a standard deviation of 15%. Assume that returns on this portfolio follow a normal distribution. [Use Excel commands instead of the z table.] a. What percentage of returns were greater than 53%? (Round your answer to 2 decimal places.)

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Excel output:

- clipboard Α1 A 0.001349898 Font Alignment l =1-NORM.DIST(53,8,15,TRUE) C D B 1 2 3

The formula to be used is: "1-norm.dist(53, 8, 15, true)"

It is showing answer is 0.0013

But we need in percentage form, hence it's 0.13%.

0.13 is the answer.

Please comment if any doubt. thank you.

0 0
Add a comment
Know the answer?
Add Answer to:
The historical returns on a balanced portfolio have had an average return of 8% and a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • The historical returns on a balanced portfolio have had an average return of 13% and a...

    The historical returns on a balanced portfolio have had an average return of 13% and a standard deviation of 16%. Assume that returns on this portfolio follow a normal distribution. [You may find it useful to reference the z table.] a. What percentage of returns were greater than 45%? (Round your answer to 2 decimal places.) b. What percentage of returns were below −35%? (Round your answer to 2 decimal places.)

  • Please provide simple explanation 6 The historical returns on a balanced portfolio have had an average...

    Please provide simple explanation 6 The historical returns on a balanced portfolio have had an average return of 10% and a standard deviation of 11%. Assume that returns on this portfolio follow a normal distribution. [You may find it useful to reference the z table.] a. What percentage of returns were greater than 43%? (Round your answer to 2 decimal places.) 5.33 points Percentage of returns 1.30: % eBook References b. What percentage of returns were below -1%? (Round your...

  • 4. The historical returns on a balanced portfolio have had an average return of 8 %...

    4. The historical returns on a balanced portfolio have had an average return of 8 % and a standard deviation of 12 %. Assume that returns on this portfolio follow a normal distribution a. What percentage of returns were greater than 20 %? b. What percentage of returns were below -16 %?

  • the historical returns on a balanced portfolio had an average return of 14% and a standard...

    the historical returns on a balanced portfolio had an average return of 14% and a standard deviation of 8%. Assume that the returns on this portfolio follow a normal distribution. A. What percentage of returns were greater than 30%? B. What percentage of returns were below -2%?

  • The historical returns on a balanced portfolio have had an average return of 11% and a...

    The historical returns on a balanced portfolio have had an average return of 11% and a standard deviation of 8%. Assume that returns on this portfolio follow a normal distribution. What percentage of returns were over 19%? What percentage of returns were negative (less than 0%)?

  • The historical returns on a portfolio had an average return of 15 percent and a standard...

    The historical returns on a portfolio had an average return of 15 percent and a standard deviation of 18 percent. Assume that returns on this portfolio follow a bell-shaped distribution. a. Approximately what percentage of returns were greater than 33 percent? (Round your answer to the nearest whole percent.) Percentage of returns b. Approximately what percentage of returns were below –21 percent? (Round your answer to 1 decimal place.) Percentage of returns

  • The historical returns on a portfolio had an average return of 24 percent and a standard...

    The historical returns on a portfolio had an average return of 24 percent and a standard deviation of 31 percent. Assume that returns on this portfolio follow a bell-shaped distribution. a. Approximately what percentage of returns were greater than 86 percent? (Round your answer to the nearest whole percent.) b. Approximately what percentage of returns were below –69 percent? (Round your answer to 1 decimal place.)

  • Please provide steps that are simple. Thank you. The historical returns on a balanced portfolio have...

    Please provide steps that are simple. Thank you. The historical returns on a balanced portfolio have had an average return of 14% and a standard deviation of 8%. Assume that returns on this portfolio follow a normal distribution. [You may find it useful to reference the z table.] a. What percentage of returns were greater than 30%? (Round your answer to 2 decimal places.) Percentage of returns 228% ces b. What percentage of returns were below -2%? (Round your answer...

  • The historical returns on a portfolio had an average return of 21 percent and a standard...

    The historical returns on a portfolio had an average return of 21 percent and a standard deviation of 29 percent. Assume that returns on this portfolio follow a bell-shaped distribution. a. Approximately what percentage of returns were greater than 79 percent? (Round your answer to the nearest whole percent.) b. Approximately what percentage of returns were below –66 percent? (Round your answer to 1 decimal place.) ____________________________________________________________________________________________________________________________ The following relative frequency distribution was constructed from a population of 400. Calculate...

  • REALIZED RATES OF RETURN NEED TO BE DONE USING EXCEL!!!! Stocks A and B have the following historical returns: Year S...

    REALIZED RATES OF RETURN NEED TO BE DONE USING EXCEL!!!! Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 24.00% - 12.10% 2012 20.50 23.70 2013 17.75 31.90 2014 - 5.25 - 11.70 2015 25.75 2.95 Calculate the average rate of return for stock A during the period 2011 through 2015. Round your answer to two decimal places. % Calculate the average rate of return for stock B during...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT