Returns Year X -2345 1 16% 22% 30 -23 31 -28 11 12 10 22 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.) Average returns % % Variances Standard deviations % %

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%

Year Returns X Y 1 11% 18% 2 25 26 3 11 10 4 −18 −23 5 10 17    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.)                 X Y Average returns   %   % Variances         Standard deviations   %   %

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

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

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.

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 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.

You have the following information: t1 t2 t3 t4 Walmart Returns 0.06 0.03 -0.01 -0.04 Market Returns -0.04 -0.01 0.08 -0.06 What is the Variance of the Market? Type your answer as decimal (i.e. 0.052 and not 5.2%). Round your answer to the nearest four decimals if needed.

Calculate the geometric mean return for the following data set: (Negative value should be indicated by a minus sign. Round your intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) -14% 15% -16% 13.7% Geometric mean return 14.1% %