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

website.