Microsoft Office Tutorials and References

In Depth Information

(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 this item on 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

remembering how to do this, see the objectives at the end of
Chapter 2
in

Sect. 2.4).

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

your spreadsheet.

(h) Save the ﬁnal spreadsheet as: TROUT10

3. According to Bremer and Doerge (2010), only one species of oak tree,
Quercus

tomentella Engelm
, grows on the island of Guadalupe. Let’s suppose that ﬁve

years ago, the average size of acorn nut as measured by length from this species

of oak was 27 millimeters (mm). Suppose that you have been asked to determine

if this average size has changed this year. You decide to run a small sample of

oak acorns to test your Excel skills, and the hypothetical data are given in

Fig.
3.12
:

Create an Excel spreadsheet with these data.

(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 this item 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

remembering how to do this, see the objectives at the end of
Chapter 2
in

Sect. 2.4).

(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