Find variance of the following stocks A,B and C:
Stock | A | B | C |
1 | 3 | 19 | -2 |
2 | 5 | 17 | 4 |
3 | 7 | 15 | 0 |
4 | 9 | 13 | 8 |
5 | 11 | 11 | 12 |
6 | 13 | 9 | 14 |
8 | 15 | 7 | -8 |
9 | 17 | 5 | 16 |
10 | 19 | 3 | 20 |
Statement showing variance
A | B | C | |||||||
Year | x | (x-X) | (x-X)^2 | y | (y-Y) | (y-Y)^2 | z | (z-Z) | (z-Z)^2 |
1 | 3 | -8 | 64 | 19 | 8 | 64 | -2 | -9.11 | 82.9921 |
2 | 5 | -6 | 36 | 17 | 6 | 36 | 4 | -3.11 | 9.6721 |
3 | 7 | -4 | 16 | 15 | 4 | 16 | 0 | -7.11 | 50.5521 |
4 | 9 | -2 | 4 | 13 | 2 | 4 | 8 | 0.89 | 0.7921 |
5 | 11 | 0 | 0 | 11 | 0 | 0 | 12 | 4.89 | 23.9121 |
6 | 13 | 2 | 4 | 9 | -2 | 4 | 14 | 6.89 | 47.4721 |
8 | 15 | 4 | 16 | 7 | -4 | 16 | -8 | -15.11 | 228.3121 |
9 | 17 | 6 | 36 | 5 | -6 | 36 | 16 | 8.89 | 79.0321 |
10 | 19 | 8 | 64 | 3 | -8 | 64 | 20 | 12.89 | 166.1521 |
99 | 240 | 99 | 240 | 64 | 688.8889 | ||||
(/) n | 9 | 9 | 9 | 9 | 9 | 9 | |||
Expected return(X,Y,Z) | 11.000 | 11.000 | 7.111 | ||||||
Variance | 26.667 | 26.667 | 76.543 |
Get Answers For Free
Most questions answered within 1 hours.