Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 7 Tables 305

Now generate the table statistics for the new table.

To generate table statistics:

1 Click Descriptive Statistics from the StatPlus menu and then click

Table Statistics.

2 Select the range A4:C10.

3 Click the Output button and send the table to a new worksheet

named Enrollment Statistics.

4 Click the OK button.

The statistics for this table are as shown in Figure 7-26.

Figure 7-25
Enrollment table
with pooled
table rows

Figure 7-26
Statistics for the
Enrollment table

statistics that don't

assume ordinal data

statistics that assume

ordinal data