Chapter 30: Analyzing Data with PivotTables
3030
summary method for a column, right-click any cell in the column and choose the
Summarize Values By and then appropriate option.■ (^) The Time field is in the Rows section. Use the Grouping dialog box to group by
hours.
Using a PivotTable to Create a Frequency Distribution
Excel provides a number of ways to create a frequency distribution, but none of these
methods is easier than using a PivotTable. Figure 30.11 shows part of a table of 221 stu-
dents 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).
FIGURE 30.11
Creating a frequency distribution for these test scores is simple.
This workbook, named frequency distribution.xlsx, is available on this book’s website at
http://www.wiley.com/go/excel2019bible.
The PivotTable is simple.
■ (^) The Score field is in the Rows section (grouped).
■ (^) Another instance of the Score field is in the Values section (summarized by Count).