Data Analysis with Microsoft Excel: Updated for Office 2007

288 Fundamentals of Statistics

Two-Way Tables

What about the relationship between two categorical variables? You might

want to see whether a calculus requirement for statistics varies by depart-

ment. Excel’s PivotTable feature can compile a table of calculus requirement

by department.

To create a PivotTable for calculus requirement by department:

1 Return to the Survey worksheet.

2 Click the PivotTable button from the Tables group on the Insert tab.

3 Click the OK button to add a new worksheet containing the Pivot-

Table tools.

4 Drag Calculus from the PivotTable Field List box and drop it into

the Column Labels box.

5 Drag the Dept fi eld to the Row Labels area.

6 Drag the Dept fi eld onto the Values area.

Excel creates a PivotTable with counts of the Dept fi eld broken down

by the Calculus fi eld. See Figure 7-12.

Figure 7-12
PivotTable of
Dept versus
Calculus