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