Microsoft Office Tutorials and References
In Depth Information
Excel provides a number of ways to create a frequency distribution, but none of those methods is easier than us-
ing a pivot table. Figure 18-30 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 at this topic's website.
Figure 18-30: Creating a frequency distribution for these test scores is simple.