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