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
problem #1
(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