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

spreadsheet.

(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

obtain?

Use three decimal places for all ﬁgures in the formula section of your

spreadsheet.

(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

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.

Search JabSto ::

Custom Search