Microsoft Office Tutorials and References

In Depth Information

Fig. 5.7

Example of a rating scale for item #12 for introductory biology 101 (practical example)

Suppose you collect these ratings and determine (using your new Excel skills)

that the 52 men in this course had a mean rating of 55 with a standard deviation of

7, while the 57 women in this course had a mean rating of 64 with a standard

deviation of 13.

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
:

Fig. 5.8 Worksheet data for

item #12 for introductory

biology 101

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
)

Search JabSto ::

Custom Search