Problem 10-7 Calculating Returns and Variability Returns Year X Y 1 19% 15% 2345 22 34 -15 -20 8 14 10 24 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. Enter your variance answers rounded to 5 decimal places, e.g., .16161.) X Y Average returns % % Variances Standard deviations % %

Returns             Year   X     y   1   17  %   20  % 2   20     32   3   11     15   4 – 7   – 18   5   10     22   Using the returns shown above, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.

10.7        Calculating Returns and Variability Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y:                                                                                                 Returns                 Year                                                       X                             Y                 1                                                              12%                        14%                 2                                                              24                           29                 3                                                              -27                          -33                 4                                                              14                           17                 5                                                              19                           37

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%

7. Calculating Returns and Variability. Using the following returns, calculate the average returns, the variances, and the standard deviations for X and Y. LO 1 Returns Year Y. 16% 36% -17 - 8 13 21 15 -15 24 39 12345

Calculate the variance of the following returns. Return Year 1 2 3 4 5 0.17 0.2 -0.17 0.24 0.03 Enter the answer with 4 decimals, e.g. 0.1234.

Average returns Variances Standard deviations > Answer is complete but not entirely correct. X Y 10.20 % 14.20 % 109.90000 X 10.48 % 362.20000 X 19.03 %

Please include excel formula   Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.                     Input area:                               Year X Y           1 13% 27%           2 26% 36%           3 7% 11%           4 -5% -29%           5 11% 16%                           (Use cells A6 to C11 from the given information to complete this question. You must use the built-in Excel function to answers this question. Make sure to use the “sample” Excel formulas.)                 Output area:                               Asset X:               Average return                 Variance                 Standard deviation                 Asset Y:               Average return                 Variance                 Standard deviation

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year X Y 1 15% 21% 2 26 36 3 7 13 4 -13 -26 5 11 15

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.    Year Returns X Y 1 9% 23% 2 27 44 3 16 -6 4 -17 -20 5 18 52     Calculate the arithmetic average return for X. Calculate the arithmetic average return for Y.