Microsoft Office Tutorials and References
In Depth Information
(a) On your Excel spreadsheet, write the null hypothesis and the research
(b) Create a table that summarizes these data on your spreadsheet and use
Excel to ﬁnd the sample sizes, the means, and the standard deviations of
the two groups in this table.
(c) Use Excel to ﬁnd the standard error of the difference of the means.
(d) Use Excel to perform a two-group t-test. What is the value of t that you
obtain (use two decimal places)?
(e) On your spreadsheet, type the critical value of t using the t-table in
(f) Type your result on the test on your spreadsheet.
(g) Type your conclusion in plain English on your spreadsheet.
(h) save the ﬁle as: FINCH3
3. Suppose that you have been asked to ‘‘run the data’’ at a local university by the
Chair of the Biology Department who wants to know if there is a gender
difference in cumulative grade-point averages (GPAs) of Biology majors who
have completed all of the required courses in their major. The Chair has
obtained the cooperation of the Registrar and has promised to keep the GPA
Fig. 5.19 :
Worksheet data for Chap. 5: practice problem #3
Search JabSto ::