Microsoft Office Tutorials and References
In Depth Information
I cover pivot tables in Chapter 18.
Figure 7-11: Summarizing grades with a pivot table and pivot chart.
Using adjustable bins to create a histogram
Figure 7-12 shows a worksheet with student grades listed in column B (67 students total). Columns D and E
contain formulas that calculate the upper and lower limits for bins, based on the entry in cell E1 (named BinS-
ize ). For example, if BinSize is 12 (as in the figure), then each bin contains 12 scores (1–12, 13–24, and so on).
The workbook adjustable bins.xlsx, shown in Figure 7-12, is available at this book's