Microsoft Office Tutorials and References
In Depth Information
(a) On your Excel spreadsheet, write the null hypothesis and the research
hypothesis.
(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
Appendix E.
(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
information
conﬁdential and
has
obtained the
hypothetical data
given
in
Fig. 5.19 :
Fig. 5.19
Worksheet data for Chap. 5: practice problem #3
(a) State
the
null
hypothesis
and
the
research
hypothesis
on
an
Excel