Data Analysis with Microsoft Excel: Updated for Office 2007

246 Fundamentals of Statistics

2 Verify that the 1-sample t test option button is selected.

3 Click the Input button and then click the Use Range Names option

button. Select Diff from the list of range names and click the OK

button.

4 Click the Output button and select the New Worksheet option but-

ton. Enter t test for the new worksheet name and click the OK but-

ton. Figure 6-12 shows the completed dialog box.

Note that we could have also selected the Paired t test (two columns)

and then selected the Year_68 and Year_72 columns. Note also that

the dialog box will test a null hypothesis of m 50 versus the alterna-

tive hypothesis of not equal to 0. You can change these values if you

wish to test other hypotheses.

Figure 6-12
The One-Sample or

Paired t Test

dialog box

Use values from a

single column

Null hypothesis is

that the mean = 0.

Alternate hypothesis

is that the mean < > 0

Break down the

analysis in terms of a

By variable

Use values from two

columns of paired data

Construct a 95%

confidence interval around

the sample average

5 Click the OK button to generate the output from the t test. See

Figure 6-13.