Microsoft Office Tutorials and References
In Depth Information
Fig. 4.6 Worksheet Data for
Chapter 4: Practice Problem
study eight years ago, the average length of the mating call in this type of frog
was 160 msec. You have collected data and want to test your Excel skills on a
small sample before you try to analyze the data from a much larger sample. The
hypothetical data appear in Fig. 4.7 .
(a) Write the null hypothesis and the research hypothesis on your spreadsheet
(b) Use Excel to find 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 file as: FROG3
Search JabSto ::

Custom Search