Microsoft Office Tutorials and References

In Depth Information

Fig. 4.5
Worksheet Data

for Chapter 4: Practice

Problem #1

ago, the average mass was 112 grams (g). You would like to know if the average

mass has changed since then. You have collected data on a sample of rainbow

trout from the same river, and you want to test your Excel skills on a small

sample before you try to do the larger data analysis. The hypothetical data for a

random sample of rainbow trout is presented in Fig.
4.6
:

(a)
On your Excel spreadsheet
, write the null hypothesis and the research

hypothesis for these data.

(b) Use Excel to ﬁnd the
sample size, mean, standard deviation, and standard

error of the mean
for these data (two decimal places for the mean, standard

deviation, and standard error of the mean).

(c) Use Excel to perform a
one-group t-test
on these data (two decimal places).

(d) On your printout, type the
critical value of t
given in your t-table in

Appendix E.

(e) On your spreadsheet, type the
result
of the t-test.

(f) On your spreadsheet, type the
conclusion
of your study in plain English.

(g) save the ﬁle as: TROUT33

3. Suppose that you wanted to study the mating call of a tree frog,
Hyla versicolor
,

by measuring the duration in milliseconds (msec) of the notes. In a previous

Search JabSto ::

Custom Search