Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 7 Tables 301

Next you want to give the two groups descriptive names and collapse the

PivotTable around the two groups you created.

To rename and collapse the PivotTable groups:

1 Click cell A5 in the PivotTable, type Other Depts, and press Enter.

2 Click the minus boxes in front of the group titles in cells A5 and A9

to collapse the groups. Figure 7-22 shows the collapsed PivotTable.

Figure 7-22
PivotTable with
grouped rows

Notice that the expected cell counts are all much greater than 5. Grouping

the rows in the PivotTable is a good way to remove problems with sparseness

in the cell counts. Now that you’ve restructured the PivotTable, rerun your

analysis, comparing the MathSci department to all of the other combined

departments.

To check the table statistics on the revised table:

1 Click Descriptive Statistics from the StatPlus menu and then click

Table Statistics.

2 Enter the range A4:C6.

3 Click the Output button and send the output to the new worksheet,

Calculus Department Table 2.

4 Click the OK button to start generating the new batch of table statis-

tics. See Figure 7-23.