Microsoft Office Tutorials and References
In Depth Information
Fig. 1.18 Worksheet Data for Chapter 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
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
class days to teach each chapter. At the end of Chapter 8 , the teacher gives a 15-
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