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
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,36

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site