Question

A portfolio's annual returns are normally distributed with a mean of 9 % and a standard...

A portfolio's annual returns are normally distributed with a mean of 9 % and a standard deviation of 24 %. Over the past 5 years, you observe an average annual return of -1 %. What is the probability of observing an average annual return over 5 years of -1 % or less? I need it to be done on the excel. Please show the steps.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text aCopy в 1 프· ー· ?. ▲· 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Alignment Number Cells Edting 187 Formula Bar 72 73 74 75 76 AVERAGE ANNUAL RETURN 9.00 24.00 STANDARD DEVIATION (SD) 10.7331 SD/SQRT(n 78 79 80 81 82 83 84 85 86 87 APPROPRIATE STANDARD DEVIATION PROBABILITY THAT RETURN WILL BE LESS THAN-1% IN A GIVEN YEAR EXCEL FUNCTION PROBABILITY- 17.57% NORM.DIST(F79,F75,F78,1) 89 90 4 MEAN STDV nment DEAR Sheet2 COV TIME SERIES corr REGRESSION CAMERAEXP RETURN MATRD< | INTERVAL, NORMAL , HYPOTHESIS 福 130% 27-01-2019

Add a comment
Know the answer?
Add Answer to:
A portfolio's annual returns are normally distributed with a mean of 9 % and a standard...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • Yearly Returns for stocks is normally distributed  around a mean of 9% with a standard deviation of...

    Yearly Returns for stocks is normally distributed  around a mean of 9% with a standard deviation of 12%. A random sample of 2000 stock returns is shown on the Stock Returns worksheet. (6) (To three decimal places) what is the probability of a stock having a negative yearly return? (7)(Tothree decimal places) what is the probability of a stock having a yearly return between 5% and 8%? (8) (To three decimal places) What is the relative frequency of stocks, from the...

  • Assume the returns from an asset are normally distributed. The average annual return for the asset...

    Assume the returns from an asset are normally distributed. The average annual return for the asset is 17.4 percent and the standard deviation of the returns is 27.5 percent. What is the approximate probability that your money will double in value in a single year?

  • A portfolio has average return of 13.2 percent and standard deviation of returns of 18.9 percent....

    A portfolio has average return of 13.2 percent and standard deviation of returns of 18.9 percent. Assuming that the portfolioi's returns are normally distributed, what is the probability that the portfolio's return in any given year is between -24.6 percent and 32.1 percent? A. 0.815 B. 0.835 ос C. 0.950 D. 0.975 A portfolio has expected return of 13.2 percent and standard deviation of 18.9 percent. Assuming that the returns of the portfolio are normally distributed, what is the probability...

  • An analyst gathered the following information about a​ portfolio's performance over the past ten​ years: Mean...

    An analyst gathered the following information about a​ portfolio's performance over the past ten​ years: Mean annual return: 11.8% Standard deviation of annual returns: ​15.7% Portfolio Beta:1.2 If the mean return on the​ risk-free asset over the same period was​ 5.0%, the Sharpe ratio for the portfolio is closest ​to: Sharpe ratio A 0.23 B 0.36 C 0.43

  • 15) Assume that z scores are normally distributed with a mean of 0 and a standard...

    15) Assume that z scores are normally distributed with a mean of 0 and a standard deviation 15) of 1. If P(z> c) 0.109, find c. olve the problem. 16) 16) Scores on an English test are normally distributed with a mean of 37.4 and a standard deviation of 7.9. Find the score that separates the top 59% from the bottom 41% 17) Suppose that replacement times for washing machines are normally distributed with a 17) mean of 10.9 years...

  • Suppose the returns on an asset are normally distributed The historical average annual return for the...

    Suppose the returns on an asset are normally distributed The historical average annual return for the asset was 76 percent and the standard deviation was 8.6 percent. What is the probability that your return on this asset will be less than 93 percent in a given year? Use the NORMDIST function in Excele to answer this question (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Probability What range of returns...

  • A stock's returns are normally distributed with a mean of 8% pa and a standard deviation...

    A stock's returns are normally distributed with a mean of 8% pa and a standard deviation of 15 percentage points pa. What is the 99% confidence interval of returns over the next year? Note that the Z-statistic corresponding to a one-tail: • 90% normal probability density function is 1.282. • 95% normal probability density function is 1.645. • 97.5% normal probability density function is 1.960. • 99% normal probability density function is 2.326. • 99.5% normal probability density function is...

  • Replacement times for televisions are normally distributed with a mean of 8.2 years and a standard...

    Replacement times for televisions are normally distributed with a mean of 8.2 years and a standard deviation of 1.1 years. Find the probability that a randomly selected television will need a replacement time less than 6 years.

  • Solve the problem. Annual precipitation in a certain city is normally distributed with a mean of...

    Solve the problem. Annual precipitation in a certain city is normally distributed with a mean of 99 inches, and a standard deviation of 18 in. Find the probability that the mean annual precipitation during 35 randomly picked years will be less than 101.8 in.? Group of answer choices 0.8212 0.3212 0.9203 0.6788 0.1788

  • Assume that the returns from an asset are normally distributed. The average annual return for this...

    Assume that the returns from an asset are normally distributed. The average annual return for this asset over a specific period was 17.1 percent and the standard deviation of those returns in this period was 43.8 percent. a. What is the approximate probability that your money will double in value in a single year? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. What about triple in value? (Do...

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