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

decimal places).

(d) Enter your
result
onto your spreadsheet.

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

Search JabSto ::

Custom Search