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 ﬁ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

decimal places).

(d) Enter your result onto your spreadsheet.

(e) Enter your conclusion in plain English onto your spreadsheet.

Search JabSto ::

Custom Search