Microsoft Office Tutorials and References

In Depth Information

**Creating a Frequency Distribution**

Following are the settings I used for this pivot table:

h
The Values area has three instances of the Reading field. I used the Data Field Setting

dialog box (Summarize Values By tab) to summarize the first instance by Average, the

second instance by Min, and the third instance by Max.

h
The Time field is in the Row Labels section, and I used the Grouping dialog box to group

by Hours.

Creating a Frequency Distribution

Excel provides a number of ways to create a frequency distribution, but none of those methods is

easier than using a pivot table. Figure 18-29 shows part of a table of 221 students and the test

score for each. The goal is to determine how many students are in each ten-point range (1–10,

11–20, and so on).

This workbook, named
test scores.xlsx
, is available on the companion CD-ROM.

Figure 18-29:
Creating a frequency distribution for these test scores is simple.