In: Finance
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Year X Y 1 11 % 23 % 2 29 44 3 18 -11 4 -19 -25 5 20 52
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. |
Returns | ||
Year | X | Y |
1 | 11 % | 23 % |
2 | 29 | 44 |
3 | 18 | -11 |
4 | -19 | -25 |
5 | 20 | 52 |
Expected Return of X
Year | Returns |
1 | 11% |
2 | 29% |
3 | 18% |
4 | -19% |
5 | 20% |
59% | |
Expected Return | 11.8% |
Expected Return of Y
Year | Returns |
1 | 23% |
2 | 44% |
3 | -11% |
4 | -25% |
5 | 52% |
83% | |
Expected Return | 16.6% |
Variance and Standard devaiation of X:
Year | Returns X | X-Avg X | (X-Avg X)^2 |
1 | 11% | -0.80% | 0.000064 |
2 | 29% | 17.20% | 0.029584 |
3 | 18% | 6.20% | 0.003844 |
4 | -19% | -30.80% | 0.094864 |
5 | 20% | 8.20% | 0.006724 |
Sum of (X-AvgX)^2 | 0.135080 | ||
Variance = [ Sum of (X-AvgX)^2 ] / n | 0.027016 | ||
SD = Sqrt of Variance | 16.44% |
Variance and Standard devaiation of Y:
Year | Returns Y | Y-Avg Y | (Y-Avg Y)^2 |
1 | 23% | 6.40% | 0.004096 |
2 | 44% | 27.40% | 0.075076 |
3 | -11% | -27.60% | 0.076176 |
4 | -25% | -41.60% | 0.173056 |
5 | 52% | 35.40% | 0.125316 |
Sum of (X-AvgX)^2 | 0.453720 | ||
Variance = [ Sum of (X-AvgX)^2 ] / n | 0.090744 | ||
SD = Sqrt of Variance | 30.12% |
Pls do rate, if the answer is correct and comment, if any further assistance is required.