Data Analysis with Microsoft Excel: Updated for Office 2007

302 Fundamentals of Statistics

Figure 7-23
Table statistics
for the grouped
PivotTable

There is little difference in our conclusion by grouping the table rows.

Once again the Pearson chi-square test statistic is highly signifi cant with a

p value of less than 0.001. Thus we would reject the null hypothesis and

accept the alternative hypothesis that the MathSci departments are more

likely to require a calculus prerequisite.

Tables with Ordinal Variables

The two-way table you just produced was for two nominal variables. The

Pearson chi-square test makes no assumption about the ordering of the

categories in the table. Now let’s look at categorical variables that have