Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 7 Tables 277

To open the Survey workbook:

1 Start Excel if necessary and maximize the Excel window.

2 Open the Survey workbook from the Chapter07 folder.

3 Save the workbook as Survey Table Statistics. The workbook appears

as shown in Figure 7-1.

Figure 7-1
Survey data

You’ve been asked to determine the relationship between the depart-

ment and whether calculus is required as a prerequisite for courses in that

department. First you’ll examine the distribution of professors in different

department categories.

In Excel, you obtain category counts by generating a PivotTable, a work-

sheet table that summarizes data from the source data list (in this case

the survey data). Excel PivotTables are interactive; that is, you can update

them whenever you change the source data list, and you can switch row

and column headings to view the data in different ways (hence the term

pivot).

Try creating a PivotTable that summarizes the number of professors in

each department. You can insert a PivotTable using the commands on the

Insert tab.