Question Using Excel I get that the SD would be 1301076 but
Question: Using Excel I get that the SD would be 130.1076, but how do I show it in written out?
Field of Study
2005
2008
Mathematics & Statistics
1,176
1,360
1,176 + 1,360 = 2,536 1,176-1,268 = -92
2,536/2 = 1,268 1,360-1,268 = 92
Mean= 1,268
SD= 130.1076
| Field of Study | 2005 | 2008 |
| Mathematics & Statistics | 1,176 | 1,360 |
Solution
Getting the mean, X,
X = Sum(x) / n
Sum(x) = 2536
As n = 2
Thus,
X = 1268
Setting up tables,
Thus, Sum(x - X)^2 = 16928
Thus, as
s^2 = Sum(x - X)^2 / (n - 1)
As n = 2
s^2 = 16928
Thus,
s = 130.1076477 [ANSWER]
| x | x - X | (x - X)^2 |
| 1176 | -92 | 8464 |
| 1360 | 92 | 8464 |
