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.
Search JabSto ::

Custom Search