Data Analysis with Microsoft Excel: Updated for Office 2007

280 Fundamentals of Statistics

2 Drag Dept from the PivotTable Field List box and drop it in the

Values box.

As shown in Figure 7-4, the PivotTable now displays the counts

within each department.

department categories

appear as row labels

PivotTable displays count

of each category

Figure 7-4

Creating the

department

PivotTable

PivotTable of

department

The department PivotTable shows the count of different departments

represented in the survey. From the table you can quickly see that there are

392 responses in the survey coming from 91 professors in business/economics,

25 professors in the health sciences, 128 professors in math and science, and

101 professors in the social sciences. There are also 47 respondents who did

not specify a department.

You can edit the PivotTable to remove the respondents that did not spec-

ify a department.

Removing Categories from a PivotTable

PivotTables include drop-down list boxes that you can use to specify which

categories are displayed in the table. Use a list box to remove respondents

that did not specify a department.