Microsoft Office Tutorials and References
In Depth Information
Fig. 4.5 Worksheet data for
Chap. 4: practice
(a) Write the null hypothesis and the research hypothesis on your spreadsheet.
(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 (2 decimal
places) for the mean, standard deviation, and standard error of the mean.
(c) Enter the critical t from the t-table in Appendix E onto your spreadsheet,
and label it.
(d) Use Excel to compute the t-value for these data (use 2 decimal places) and
label it on your spreadsheet.
(e) Type the result on your spreadsheet, and then type the conclusion in plain
English on your spreadsheet.
(f) Save the ﬁle as: PETAL3.
2. Suppose that you wanted to study the mass (in grams) of rainbow trout (On-
corhynchus mykiss) in a river in southern Colorado in the U.S. Five years 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
Search JabSto ::