Microsoft Office Tutorials and References
In Depth Information
(a) Use Excel to the right of the table to ﬁnd the sample size, mean, standard
deviation, and standard error of the mean for these data. Label your
answers, and round off the mean, standard deviation, and standard error of
the mean to two decimal places; use number format for these three ﬁgures.
(b) Print the result on a separate page.
(c) Save the ﬁle as: seed 3.
2. Suppose that you have been hired as a research assistant and that you have been
asked to determine the percent of butterfat in registered three-year-old Ayrshire
cows in the state of Montana in the USA. You manage to ﬁnd a recent ‘‘stock
record book’’ with these data for this breed of cow in Montana, and you take a
random sample of cows and record the percent of butterfat of each of these
cows from the stock record book. The hypothetical data are given in Fig. 1.18 .
Fig. 1.18
Worksheet Data for Chap. 1: Practice Problem #2
(a) Use Excel to create a table of these data, and at the right of the table use
Excel to ﬁnd the sample size, mean, standard deviation, and standard error
of the mean for these data. Label your answers, and round off the mean,
standard deviation, and standard error of the mean to two decimal places
using number format.
(b) Print the result on a separate page.
(c) Save the ﬁle as: COWS3.
Search JabSto ::

Custom Search