Microsoft Office Tutorials and References

In Depth Information

(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

3. Suppose that a 5
th
grade elementary science teacher in Fairbanks, Alaska, is

using a textbook based on human anatomy that typically requires about eight

item true-false quiz on this chapter. The hypothetical test results are given in

Fig.
1.19
:

(a) Use Excel to create a table for 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 three decimal places

using number format.

Search JabSto ::

Custom Search