Microsoft Office Tutorials and References

In Depth Information

Excel skills on a small sample before you try to analyze the data from a much

larger sample. The hypothetical data appear in Fig.
4.7
.

Fig. 4.7 Worksheet data for

Chap. 4: practice

problem #3

(a) Write the null hypothesis and the research hypothesis on your spreadsheet.

(b) Use Excel to ﬁnd the sample size, mean, standard deviation, and standard

error of the mean to the right of the data set. Use number format (2 decimal

places) for the mean, standard deviation, and standard error of the mean.

(c) Enter the critical t from the t-table in Appendix E onto your spreadsheet,

and label it.

(d) Use Excel to compute the t-value for these data (use 2 decimal places) and

label it on your spreadsheet.

Search JabSto ::

Custom Search