Given the following historical returns, what is the variance? Year 1 = 9%; year 2 = -11%; year 3 = 8%; year 4 = -12%; and year 5 = -9%. the correct answer is .0112. How was that found? Please do not answer in excel format

Given the following historical returns, what is the variance? Year 1 = 9%; year 2 = -11%; year 3 = 8%; year 4 = -12%; and year 5 = -9%. the correct answer is .0112. How was that found? Please do not answer in excel format

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Please do not give solution in image format thanku
Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B30 enter the formula "= B20". Notes: In the text, variances are always displayed as positive numbers. To accomplish this, you can use the ABS() function in Excel. For example, the formula in cell C31 would be "=ABS(E31-B31)". Cells D31 through D39 and G31 through G39 already contain formulas to compute and display whether variances are Favorable or Unfavorable. Do not enter data or formulas into those cells-if you do, you will overwrite these formulas. After entering formulas in all of the cells that contained question marks, verify that the amounts match the numbers in the example in the text. Required: 1. Check your worksheet by changing the revenue in cell D4 to $16.00; the cost of ingredients in cell D5 to $6.50; and the wages and salaries in cell B6 to $10,000. The activity variance for net operating income should now be $850 U and the spending variance for total…
Year INM +5 3 4 Returns 14% 28 9 10 Y 18% 29 10 -26 20 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 answers as a percent rounded to 2 decimal places, e.g., 32.16, and round the variance answers to 5 decimal places, e.g., 16161.) Average returns Variances Standard deviations X 8.00 % 17.90 % Y 10,20 % 21.34 %
Isn't the 0.0592 in part 2 the variance? By squaring that you should get 24%?
Use the following returns for X and Y. Year 1 2 3 4 5 Returns X 22.1% -17.1 10.1 20.2 5.1 Y 27.3% -4.1 29.3 -15.2 33.3 a. Calculate the average returns for X and Y. Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. b. Calculate the variances for X and Y. Note: Do not round intermediate calculations and round your answers to 6 decimal places, e.g., .161616. c. Calculate the standard deviations for X and Y. Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. X Answer is complete but not entirely correct. X 8.06 a. Average return b. Variance c. Standard deviation 136.454400 % 11.67 X % Y 14.04 377.286400 x % 19.42%
Year a. b. 12345 C. Returns X 22.0% 17.0 10.0 20.0 5.0 a. Calculate the average returns for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b. Calculate the variances for X and Y. (Do not round intermediate calculations and round your answers to 6 decimal places, e.g., 32.161616.) c. Calculate the standard deviations for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Y 27.0% 4.0 29.0 - 15.0 33.0 X Answer is complete but not entirely correct. Average return Variance Standard deviation X 8.00 2.445000 x 15.64 % % Y 14.72 X % 4.501920 X 21.22 X %
Am. 157.
Use the following returns for X and Y. Returns Year x y 1 21.8% 26.4% 2 -16.8 -3.8 3 9.8 28.4 4 19.6 -14.6 5 4.8 32.4 a. Calculate the average returns for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b. Calculate the variances for X and Y. (Do not round intermediate calculations and round your answers to 6 decimal places, e.g., 32.161616.) c. Calculate the standard deviations for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)
q8- When visualising the distribution of a variable using a histogram, if only the right tail has outliers, the data distribution is: a. Right-skewed b. Normal c. Left-skewed d. Uniform
Consider a population proportion p = 0.20. a. What are the expected value and the standard error for the sampling distribution of the sample proportion with n = 20 and n = 58? Note: Round the standard error to 4 decimal places. Answer is complete and correct. n Expected value Standard error 20 58 0.20 0.20 0.0894 0.0525 b. Can you conclude that the sampling distribution of the sample proportion is approximately normally distributed for both sample sizes? Yes, the sampling distribution of the sample proportion is normally distributed for both sample sizes. No, the sampling distribution of the sample proportion is not normally distributed for either sample size. No, only the sample proportion with n = 20 will have a normal distribution. No, only the sample proportion with n = 58 will have a normal distribution. c. If the sampling distribution of the sample proportion is normally distributed with n = 20, then calculate the probability that the sample proportion is between 0.18 and 0.20.…
4. Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year 1 2 3 4 5 X 12% 28% 9% -7% 10% Return Y 25% 34% 13% -27% 14%
None

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS