Microsoft Office Tutorials and References
In Depth Information
16. What is the conclusion of the ANOVA t-test comparing Premed students
versus Other Science majors in plain English?
3. Suppose that you wanted to study the effect of ‘‘crowding’’ on the weight of
brown trout (Salmo trutta) raised in a ﬁsh hatchery in the state of Colorado in
the U.S.A. Crowding is measured in terms of the number of trout raised in a
container (i.e., the density of the ﬁsh in the container) and the weight of the
ﬁsh is measured in grams. The trout have been raised in four containers (200,
350, 500, and 700 ﬁsh per container) for nine months. You decide to take a
random sample of trout from each of the four containers. The hypothetical
data for this study are given in Fig. 8.8 .
Fig. 8.8
Worksheet Data for Chap. 8: Practice Problem #3
(a) Enter these data on an Excel spreadsheet.
(b) Perform a one-way ANOVA test on these data, and show the resulting
ANOVA table underneath the input data for the four types of crowding.
(c) If the F-value in the ANOVA table is signiﬁcant, create an Excel formula to
compute the ANOVA t-test comparing the average weight for 350 ﬁsh per
container against the average weight for 500 ﬁsh per container, and show
Search JabSto ::

Custom Search