Computation of the test statistic and p-value:
• In cell E7, use the formula = (E3 − E4)/(E5/SQRT(E6)) to compute the test statistic t (= −4.970).
• Click on cell E8 and then select the Insert Function button on the Excel toolbar.
• In the Insert Function dialog box, select Statistical from the “Or select a category:” menu, select TDIST from the “Select a function:” menu, and click OK in the Insert Function dialog box.
• In the TDIST Function Arguments dialog box, enter abs(E7) in the X window.
• Enter 14 in the Deg_freedom window.
• Enter 1 in the Tails window to select a one-tailed test.
• Click OK in the TDIST Function Arguments dialog box.
• The p-value related to the test will be placed in cell E8.
Appendix 9.3: One-Sample Hypothesis Testing Using MegaStat
The instructions in this section begin by describing the entry of data into an Excel worksheet. Alternatively, the data may be loaded directly from the data disk included with the text. The appropriate data file name is given at the top of each instruction block. Please refer to Appendix 1.2 for further information about entering data and saving and printing results in Excel. Please refer to Appendix 1.3 for more information about using MegaStat.