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