Microsoft Office Tutorials and References
In Depth Information
Fig. 4.5 Worksheet Data
for Chapter 4: Practice
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
(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 ::