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.