Microsoft Office Tutorials and References
In Depth Information
(f) Print the ﬁnal spreadsheet to ﬁt onto one page (if you need help
(g) On your printout, draw a diagram of this 95 % conﬁdence interval by
(h) Save the ﬁle as: yield3.
2. Suppose that a ﬁsh hatchery in the state of Colorado has asked you to determine
the average weight of the trout they are releasing into streams and lakes in
Colorado. If the ﬁsh are too small, licensed ﬁshermen complain about the
undersized ﬁsh being caught. If the ﬁsh are too large, the rate of feeding the ﬁsh
is too high (i.e., ﬁsh size increases with the amount of feed), it costs the state
more to feed the ﬁsh than was built into the hatchery budget.
Let’s suppose that the state wants the average weight of the trout released into
streams and lakes from a ﬁsh hatchery to be 308 grams (g) or 11 oz. (Note:
There are 28 g in one ounce.) Suppose you have been asked to analyze the
hypothetical data in Fig. 3.11 which gives the weight of a random sample of
trout released during the past week from a Colorado hatchery. The hypothetical
data are given in Fig. 3.11 .
Worksheet data for Chap. 3: practice problem #2
Create an Excel spreadsheet with these data.
Search JabSto ::