Microsoft Office Tutorials and References
In Depth Information
(a) Use Excel to the right of the table to find the sample size, mean, standard
deviation, and standard error of the mean for these data. Label your answers,
and use two decimal places for the mean, standard deviation, and standard
error of the mean
(b) Enter the null hypothesis and the research hypothesis for this item on your
spreadsheet.
(c) Use Excel’s TINV function to find the 95% confidence interval about the
mean for these data. Label your answers on your spreadsheet. Use two
decimal places for the lower limit and the upper limit of the confidence
interval.
(d) Enter the result of the test on your spreadsheet.
(e) Enter the conclusion of the test in plain English on your spreadsheet.
(f) Print your final spreadsheet so that it fits onto one page (if you need help
remembering how to do this, see the objectives at the end of Chapter 2 in
Sect. 2.4).
(g) Draw a picture of the confidence interval, including the reference value, onto
your spreadsheet.
(h) Save the final spreadsheet as: TROUT10
3. According to Bremer and Doerge (2010), only one species of oak tree, Quercus
tomentella Engelm , grows on the island of Guadalupe. Let’s suppose that five
years ago, the average size of acorn nut as measured by length from this species
of oak was 27 millimeters (mm). Suppose that you have been asked to determine
if this average size has changed this year. You decide to run a small sample of
oak acorns to test your Excel skills, and the hypothetical data are given in
Fig. 3.12 :
Create an Excel spreadsheet with these data.
(a) Use Excel to the right of the table to find the sample size, mean, standard
deviation, and standard error of the mean for these data. Label your answers,
and use two decimal places for the mean, standard deviation, and standard
error of the mean
(b) Enter the null hypothesis and the research hypothesis for this item onto your
spreadsheet.
(c) Use Excel’s TINV function to find the 95% confidence interval about the
mean for these data. Label your answers on your spreadsheet. Use two
decimal places for the lower limit and the upper limit of the confidence
interval.
(d) Enter the result of the test on your spreadsheet.
(e) Enter the conclusion of the test in plain English on your spreadsheet.
(f) Print your final spreadsheet so that it fits onto one page (if you need help
remembering how to do this, see the objectives at the end of Chapter 2 in
Sect. 2.4).
(g) Draw a picture of the confidence interval, including the reference value, onto
your spreadsheet.
(h) Save the final spreadsheet as: acorn10
Search JabSto ::




Custom Search