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 | 

