Microsoft Office Tutorials and References

In Depth Information

Fig. 3.11
Worksheet Data for Chapter 3: Practice Problem #2

(f) Print the ﬁnal spreadsheet to ﬁt onto one page (if you need help remembering

how to do this, see the objectives at the end of
Chapter 2
in Sect. 2.4)

(g) On your printout, draw a diagram of this 95% conﬁdence interval by hand

(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 ounces (oz.).

(Note: There are 28 grams 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
.

Create an Excel spreadsheet with these data.

Search JabSto ::

Custom Search