Microsoft Office Tutorials and References
In Depth Information
Tip 80: Creating a Quick Frequency Tabulation
Creating a Quick Frequency Tabulation
This tip describes a quick method for creating a frequency tabulation for a single column of data.
Figure 80-1 shows a small part of a range that contains more than 20,000 rows of city and state data.
The goal is to tally the number of times each state appears in the list.
Although you can tally the states in a number of ways, a pivot table is the easiest choice for this task.
Figure 80-1: You can use a pivot table to generate a frequency tabulation for these state abbreviations.
Before you get started on this task, make sure that your data column has a heading. In this example,
it’s in cell B1.
Activate any cell in the column A or B and then follow these steps:
1. Choose Insert ➜ Tables ➜ PivotTable.
The Create PivotTable dialog box appears.