Calculating Returns and Variability [ LO1] Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Ro the standard deviation, use the Excel function SQRT.

See the file. You must use the SQRT Function to answer the question as requested

7. Calculating Returns and Variability [ LO1] Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Ro the standard deviation, use the Excel function SQRT. Returns Year 1 2 3 4 5 X 17% 22 8 -15 10 Y 23% 34 11 -32 21 Actual Return X 1 2 3 4 5 Total Average return Variance Standard Deviation 0 0 0.00% Actual Return Y 1 2 3 4 5 Total Average return Variance Standard Deviation 0.00% Average Return Deviation Squared Deviation Average Return Deviation Squared Deviation