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.

Year X Y

1 17% 23%

2 22 34

3 8 11

4 -15 -32

5 10 21

X	Actual Return	Average Return	Deviation	Squared Deviation
1
2
3
4
5
Total	-			-
Average return	0.00%
Variance	-
Standard Deviation	0.00%
Y	Actual Return	Average Return	Deviation	Squared Deviation
1
2
3
4
5
Total	-			-
Average return	0.00%
Variance	-
Standard Deviation	0.00%