Microsoft Office Tutorials and References
In Depth Information
Fig. 3.10 Worksheet Data for Chapter 3: Practice Problem #1
and to check their annual milk yield at the end of the current year. You decide to
test your Excel skills on a small number of cows, and the hypothetical data (in
hundreds of pounds) appear in Fig. 3.10 :
(a) To the right of this table, use Excel to find the sample size, mean, standard
deviation, and standard error of the mean for the yield figures. Label your
answers. Use number format (two decimal places) for the mean, standard
deviation, and standard error of the mean.
(b) Enter the null hypothesis and the research hypothesis onto your spreadsheet.
(c) Use Excel’s TINV function to find the 95% confidence interval about the
mean for these figures. Label your answers. Use number format (two
decimal places).
(d) Enter your result onto your spreadsheet.
(e) Enter your conclusion in plain English onto your spreadsheet.
Search JabSto ::




Custom Search