Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 6 Statistical Inference 261

3 Click the Data Values button and select Revenue from the list of

range names.

4 Click the Categories button and select Location from the range

names list.

5 Click the Use Unpooled Variance option button.

6 Click the Output button and direct the output to a new worksheet

named t test. Set the output type to Dynamic.

Figure 6-19 shows the completed dialog box.

Figure 6-19

The Two-

Sample

t-Test

dialog box

use an

unpooled

variance

estimate

7 Click the OK button to generate the two-sample t test. Figure 6-20

shows the completed output.