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.