Microsoft Office Tutorials and References
In Depth Information
E13: 2 Region B
F11: n
G11: Mean
H11: STDEV
Your spreadsheet should now look like Fig. 5.14 .
Now you need to use your Excel skills from Chapter 1 to fill in the sample
sizes (n), the Means, and the Standard Deviations (STDEV) in the Table in cells
F12:H13. Be sure to double-check your work or you will not be able to obtain the
correct answer to this problem if you have only one incorrect figure!
Since both groups have a sample size less than 30, you need to use Formula #2
for the t-test for the difference of the means of two independent samples.
Formula #2 for the two-group t-test is the following:
X 1
X 2
S X 1 X 2
t
¼
(5.1)
Where
s
ð
S 1 þð
S 2
n 1
1
Þ
n 2
1
Þ
1
n 1 þ
1
n 2
S X 1 X 2 ¼
(5.5)
n 1 þ
n 2
2
¼
df
¼
n 1 þ
n 2
and where degrees of freedom
2
(5.6)
This formula is complicated, and so it will reduce your chance of making a
mistake in writing it if you “break it down into pieces” instead of trying to write the
formula as one cell entry.
Now, enter these words on your spreadsheet:
E16: (n1 – 1) x STDEV1 squared
E19: (n2 – 1) x STDEV2 squared
E22: n 1 þ
n 2 –2
E25: 1/n 1 þ
1/n 2
E28: s.e.
E31: critical t
E34: t-test
B37: Result:
B40: Conclusion: (see Fig. 5.15 )
You now need to use your Excel skills to compute the values of the above
formulas in the following cells:
H16: the result of the formula needed to compute cell E16 ( use 2 decimals)
H19: the result of the formula needed to compute cell E19 (use 2 decimals)
H22: the result of the formula needed to compute cell E22
Search JabSto ::




Custom Search