Microsoft Office Tutorials and References
In Depth Information
Creating a Frequency Distribution
The pivot table is simple:
h The Score field is in the Row Labels section (grouped).
h Another instance of the Score field is in the Values section (summarized by Count).
The Grouping dialog box that generated the bins specified that the groups start at 1 and end at
100, in increments of 10.
By default, Excel does not display items with a count of zero. In this example, no test
scores are below 21, so the 1–10 and 11–20 items are hidden. To display items that have
no data, choose PivotTable Tools
Field Settings. In the Field
Settings dialog box, click the Layout & Print tab. Then select the check box labeled
Show Items with No Data.
Figure 18-30 shows the frequency distribution of the test scores, along with a pivot chart, created
by choosing PivotTable Tools
Figure 18-30: The pivot table and pivot chart shows the frequency distribution for the test scores.