Microsoft Office Tutorials and References

In Depth Information

Fig. 3.12

Worksheet data for Chap. 3: practice problem #3

(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 use two decimal places for the mean, standard deviation, and

standard error of the mean.

(b) Enter the null hypothesis and the research hypothesis for these data onto

your spreadsheet.

(c) Use Excel’s TINV function to ﬁnd the 95 % conﬁdence interval about the

mean for these data. Label your answers on your spreadsheet. Use two

decimal places for the lower limit and the upper limit of the conﬁdence interval.

(d) Enter the result of the test on your spreadsheet.

(e) Enter the conclusion of the test in plain English on your spreadsheet.

(f) Print your ﬁnal spreadsheet so that it ﬁts onto one page (if you need help

(g) Draw a picture of the conﬁdence interval, including the reference value,

onto your spreadsheet.

(h) Save the ﬁnal spreadsheet as: acorn10.

Search JabSto ::

Custom Search