304 Fundamentals of Statistics
In the table you just created, Excel automatically arranges the Enroll B
levels in a combination of numeric and alphabetic order (alphanumeric or-
der), so be careful with category names. For example, if 051–100 were writ-
ten as 51–100 instead, Excel would place it near the bottom of the table
because 5 comes after 1, 2, 3, and 4.
Remember that most of the expected values should exceed 5, so there is
cause for concern about the sparsity in the second column between 201 and
500, but because only 4 of the 16 cells have expected values less than 5, the
situation is not terrible. Nevertheless, let’s combine enrollment levels from
200 to 500 of the PivotTable.To combine levels, use the same procedure you did with the calculus
requirement table:1 Highlight A9:A11, the enrollment row labels for the categories from
200 through 500.
2 Click the Group Selection button from the Group on the Options tab
of the PivotTable Tools ribbon.
3 Click cell A4, type Enrollment, and press Enter.
4 Click cell A13, type 201–500, and press Enter.
5 Click the minus boxes in front of all of the row categories to collapse
them. See Figure 7-25.Figure 7-24
Table of
Enrollment
versus
Calculus
Prerequisite