Microsoft Office Tutorials and References
In Depth Information
C41: the body length of queen honeybees in Region B (20.84 vs. 18.90).
Save your ﬁle as: Honey14
Print the ﬁnal spreadsheet so that it ﬁts onto one page.
Write the null hypothesis and the research hypothesis by hand on your printout.
The ﬁnal spreadsheet appears in Figure 5.17 .
5.4 End-of-Chapter Practice Problems
1. Suppose that you wanted to compare the wing length (in mm) of a species of
adult mosquitoes in the northeast region and the southeast region of the United
States. You have obtained the cooperation of other biologists in Vermont and
New Hampshire in the northeast region, and Kentucky and South Carolina in the
southeast region who have shared their data with you from a previous study. In
the North, 124 mosquitoes had wings with a mean length 3.2 mm and a standard
deviation of 1.2 mm. In the South, 135 mosquitoes had wings with a mean length
of 3.4 mm with a standard deviation of 1.3 mm.
(a) State the null hypothesis and the research hypothesis on an Excel
(b) Find the standard error of the difference between the means using Excel
(c) Find the critical t value using Appendix E, and enter it on your spreadsheet.
(d) Perform a t-test on these data using Excel. What is the value of t that you
Use three decimal places for all ﬁgures in the formula section of your
(e) State your result on your spreadsheet.
(f) State your conclusion in plain English on your spreadsheet.
(g) Save the ﬁle as: Mosquito3
2. Suppose that you wanted to determine the effect of food quality on the
development of house ﬁnches ( Carpodacus mexicanus ). To test the effect of food quality
on house ﬁnch development, you randomly assigned ﬁnches to an Experimental
group and a Control group. The Experimental group received a special diet of
high-quality food, and the Control group received its regular diet of food, during
a 120-day period. You then measured their mass (in grams). You want to test
your Excel skills on the hypothetical data given in Fig. 5.18 .
(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.
Search JabSto ::