Microsoft Office Tutorials and References
In Depth Information
annual milk yield per cow on this farm was 6,800 pounds (lbs.) in two-year-old
registered Jersey cows. You have been asked to take a random sample of cows
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 :
Fig. 3.10 Worksheet data
for Chap. 3: practice
(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.
(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 ::