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

Problem #3

(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 ::

Custom Search