Microsoft Office Tutorials and References
In Depth Information
3. Suppose that a 5th 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 Chap. 8 , the teacher gives a 15-item true–false
quiz on this chapter. The hypothetical test results are given in Fig. 1.19 :
Fig. 1.19 Worksheet Data
for Chap. 1: Practice
(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.
(b) Print the result on a separate page.
(c) Save the ﬁle as: SCIENCE9.
Search JabSto ::