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 ﬁnd the sample size, mean, standard
deviation, and standard error of the mean for the yield ﬁgures. 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 ﬁnd the 95% conﬁdence interval about the
mean for these ﬁgures. Label your answers. Use number format (two
(d) Enter your result onto your spreadsheet.
(e) Enter your conclusion in plain English onto your spreadsheet.
Search JabSto ::