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

problem #2

(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

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

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 ::

Custom Search