Data Analysis with Microsoft Excel: Updated for Office 2007

290 Fundamentals of Statistics

On the basis of the percentages you can quickly observe that for most

departments calculus is not a prerequisite for statistics, except for courses

in the math or science departments in which more than one-third of the

courses have such a requirement.

How do these percentages compare to the overall total number of respon-

dents in the survey? Let’s fi nd out.

To calculate percentages of the total responses in the survey:

1 Right-click any cell in the PivotTable and click Value Field Settings

from the pop-up menu.

2 Click the Show values as tab and select % of total from the Show

values as list box. Click the OK button. Figure 7-15 shows the revised

PivotTable.

Figure 7-14
Two-way table
of percentages

Figure 7-15

Percentages

of the total