Microsoft Office Tutorials and References

In Depth Information

Fig. 5.9 Results of widening

column B and centering the

numbers in the cells

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.

B25:

critical t

B28:

t-test

B31:

Result:

B36:

Conclusion: (see Fig.
5.10
)

Search JabSto ::

Custom Search