Data Analysis with Microsoft Excel: Updated for Office 2007

282 Fundamentals of Statistics

The PivotTable now shows a grand total of 345 respondents with the

blank department category removed from the table.

Changing the Values Displayed by the PivotTable

By default, the PivotTable displays the count for each cell in the table. You

can choose a variety of other types of values to display, including sums,

maximums, minimums, averages, and percentages. When you choose to dis-

play percentages, you can show the percentage of all of the cells in the table

or the percentage within each row or column. Try this now by changing the

table to show the percentage for each category.

To display percentages of the values within the columns:

1 Right-click any of the count values in the PivotTable, and then click

Value Field Settings from the pop-up menu.

2 Click the Show values as tab in the Value Field Settings dialog box.

3 Click % of column from the Show values as list box and then click

the OK button.

The PivotTable is modified to show values as percentages of the

total rather than as counts. See Figure 7-7.

Figure 7-7

PivotTable

showing

percentages

You can see at a glance that 26.38% of professors who listed their depart-

ment came from business/economics, 7.25% came from the health sciences,

37.10% came from math and science, and 29.28% came from the social

sciences.