Microsoft Office Tutorials and References
In Depth Information
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 :
Fig. 4.6 Worksheet data for
Chap. 4: practice
(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 to the right of the data set. Use number format 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
(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
study eight years ago, the average length of the mating call in this type of frog
was 160 milliseconds (msec). You have collected data and want to test your
Search JabSto ::