Data Analysis with Microsoft Excel: Updated for Office 2007

420 Statistical Methods

To create a two-way table:

1 Return to the Cola Data worksheet.

2 Click Manipulate Columns from the StatPlus menu and then click

Create Two-Way Table.

3 Click the Data Values button, select Foam from the range name list,

and click OK.

4 Click the Column Levels button, select Cola from the list of range

names, and click OK.

5 Click the Row Levels button, and select Type from the range names.

Click OK.

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

named Two-Way Table. Figure 10-20 shows the completed dialog box.

Figure 10-20
The Make a
Two-way
Table dialog

box

7 Click OK.

The structure of the data on the Two-Way Table worksheet now resembles

Figure 10-19, and you can now use the Analysis ToolPak to compute the

two-way ANOVA.

To calculate the two-way analysis of variance:

1 Click the Data Analysis button from the Analysis group on the Data

tab, then click Anova: Two-Factor With Replication in the Analysis

Tools list box, and then click OK.

2 Type A2:E14 in the Input Range text box, press [Tab].