Microsoft Office Tutorials and References
In Depth Information
Fig. 5.9 Results of Widening Column B and Centering the Numbers in the Cells
Note that the two-group t-test does not require that both groups have the same
sample size. This is another way of saying that the two-group t-test is “robust” (a
fancy term that statisticians like to use).
Your data then produce the following table in Fig. 5.8 :
Create an Excel spreadsheet, and enter the following information:
B3: Group
B4: 1 Males
B5: 2 Females
C3: n
D3: Mean
E3: STDEV
C4: 52
D4: 55
E4: 7
C5: 57
D5: 64
E5: 13
Now, widen column B so that it is twice as wide as column A, and center the six
numbers and their labels in your table (see Fig. 5.9 )
B8: Null hypothesis:
B10: Research hypothesis:
Since both groups have a sample size greater than 30, you need to use Formula
#1 for the t-test for the difference of the means of the two groups.
Let’s “break this formula down into pieces” to reduce the chance of making a
mistake.
B13: STDEV1 squared / n1 (note that you square the standard deviation of Group 1,
and then divide the result by the sample size of Group 1)
B16: STDEV2 squared / n2
B19: D13
þ
D16
B22: s.e.
Search JabSto ::




Custom Search