ZuoTi.Pro
Question

Q.1 Consider the following table End of Year Return 1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 71.11% 81.03 95.18 96.38 121.58 138.Use Excel to answer the following questions (learn liow to calculate mean and variance on Excel): a. Calculate arithmetic ave

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

Bookt - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIE Insert Function Q E Define Name AutoSum Recently Financial LogC D G 85 79 90 VARP VAR.P VARPA E F Population variance 36.41 =VARP(B2:311) 36.41 =VAR.P(B2:311) 36.41 =VARPA(B2:311) 88 A B

See the above image how to find mean and variance in excel.

By using excel,  

Mean = 185.957

Variance = 7982.118

① A Bithmetic average Exi 9 2975.34 16 RA 185.957 Geometric mean (1 121 16 2975.31 165.40 Geometric average = RG 165.40 3 RG

0 0
Add a comment
Know the answer?
Add Answer to:
Q.1 Consider the following table End of Year Return 1 2 4 5 6 7 8...
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

  • Consider the following five monthly​ returns: 4% -2%. 3%. 8%. -1% a. Calculate the geometric average...

    Consider the following five monthly​ returns: 4% -2%. 3%. 8%. -1% a. Calculate the geometric average monthly return over this period. b Calculate the arithmetic average monthly return over this period and express your answer as a percentage per month. c. Calculate the monthly variance over this period. d. Calculate the monthly standard deviation over this period.

  • Consider the following five monthly​ returns: 7​% −3​% 5​% 11​% −1​% a. Calculate the arithmetic average...

    Consider the following five monthly​ returns: 7​% −3​% 5​% 11​% −1​% a. Calculate the arithmetic average monthly return over this period and express your answer as a percentage per month. b. Calculate the geometric average monthly return over this period. c. Calculate the monthly variance over this period. d. Calculate the monthly standard deviation over this period.

  • 11. Consider the following returns of a portfolio: | Jan 2% | Feb 5% | Mar...

    11. Consider the following returns of a portfolio: | Jan 2% | Feb 5% | Mar -6% | Apr 3% | May -2% | Jun 4% | A. Calculate the arithmetic average monthly return (1 point) B. Calculate the geometric average monthly return (1 point) C. Calculate the monthly variance (2 points)

  • Returns Year X Y 1 11 % 23 % 2 15 26 3 10 11 4 – 13 – 14 5 10 16  &nbsp...

    Returns Year X Y 1 11 % 23 % 2 15 26 3 10 11 4 – 13 – 14 5 10 16    Using the returns shown above, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. (Do not round intermediate calculations. Enter your average return and standard deviation as a percent rounded to 2 decimal places, e.g., 32.16, and round the variance to 5 decimal places, e.g., 32.16161.)    X Y   Average...

  • Consider the rate of return of stocks ABC and XYZ. 14 Year 2 3 ABC 20%...

    Consider the rate of return of stocks ABC and XYZ. 14 Year 2 3 ABC 20% 10 15 4 1 ΓΧΥΣ sex 12 18 1 -11 00:32:02 5 a. Calculate the arithmetic average return on these stocks over the sample period. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Arithmetic Average ABC |XYZ b. Which stock has greater dispersion around the mean return? XYZ ОАВС c. Calculate the geometric average returns of each stock. What do...

  • Returns Year 1 12 % 25% 28 34 3 13 - 7 -27 4 5 10...

    Returns Year 1 12 % 25% 28 34 3 13 - 7 -27 4 5 10 14 Using the returns shown above, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. (Do not round intermediate calculations. Enter your average return and standard deviation as a percent rounded to 2 decimal places, e.g., 32.16, and round the variance to 5 decimal places, e.g., .16161.) х Y Average return Variance Standard deviation 11.80 % 10.40 %...

  • pleaseee help Consider the following five monthly returns: 0.09 0.02 0.08 0.12 0.03 a. Calculate the...

    pleaseee help Consider the following five monthly returns: 0.09 0.02 0.08 0.12 0.03 a. Calculate the arithmetic average monthly return over this period, b. Calculate the geometric average monthly return over this period. c. Calculate the monthly variance over this period. d. Calculate the monthly standard deviation over this period. a. Calculate the arithmetic average monthly return over this period. The arithmetic average is %. (Round to two decimal places.) b. Calculate the geometric average monthly return over this period....

  • Year 1. 2 3 4 5 Returns X Y 12 % 25 % 28 34 9...

    Year 1. 2 3 4 5 Returns X Y 12 % 25 % 28 34 9 13 - 7 - 27 10 14 Using the returns shown above, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. (Do not round intermediate calculations. Enter your average return and standard deviation as a percent rounded to 2 decimal places, e.g., 32.16, and round the variance to 5 decimal places, e.g., .16161.) % % Average return Variance...

  • answer A-D please Consider the following five monthly returns: 0.01 -0.06 0.04 -0.05 a. Calculate the...

    answer A-D please Consider the following five monthly returns: 0.01 -0.06 0.04 -0.05 a. Calculate the arithmetic average monthly return over this period. b. Calculate the geometric average monthly return over this period. c. Calculate the monthly variance over this period. d. Calculate the monthly standard deviation over this period. a. Calculate the arithmetic average monthly return over this period. The arithmetic average is %. (Round to two decimal places.)

  • The following are annual rates of return for U.S. government T-bills and U.K. common stocks. Year...

    The following are annual rates of return for U.S. government T-bills and U.K. common stocks. Year U.S Government T-Bills U.K Government Common Stock Year US Govt T-bills UK Common Stock 2012 0.063 0.150 2013 0.081 0.043 2014 0.076 0.374 2015 0.090 0.192 2016 0.085 0.106 a. Compute the arithmetic mean rate of return and standard deviation of rates of return for the two series. b. Discuss these two alternative investments in terms of their arithmetic average rates of return and...

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