Data Analysis with Microsoft Excel: Updated for Office 2007

288 Fundamentals of Statistics Two-Way Tables What about the relationship between two categorical variables? You might want to s ...

Chapter 7 Tables 289 When you created the fi rst PivotTable, you hid the blank category levels for the table. Do this as well fo ...

290 Fundamentals of Statistics On the basis of the percentages you can quickly observe that for most departments calculus is not ...

Chapter 7 Tables 291 On the basis of this table, almost 18% of the professors in the survey teach a class that has calculus as a ...

292 Fundamentals of Statistics require calculus is higher than expected under the null hypothesis. The ex- pected count can also ...

Chapter 7 Tables 293 The command generates some output in addition to the table of expected counts shown in Figure 7-16, which w ...

294 Fundamentals of Statistics Figure 7-17 χ^2 distribution Unlike the normal distribution and t distribution, the x^2 distribut ...

Chapter 7 Tables 295 Like the normal and t distributions, the x^2 distribution has a critical boundary for rejecting the null hy ...

296 Fundamentals of Statistics Table 7-2 Counts for Calculus Requirement by Department Observed Expected Difference 74 73.23 0.7 ...

Chapter 7 Tables 297 Breaking Down the Chi-Square Statistic The value of the Pearson chi-square statistic is built up from every ...

298 Fundamentals of Statistics Table 7-4 StatPlus Table Statistics Statistic Description Pearson chi-square Calculates the diffe ...

Chapter 7 Tables 299 Goodman-Kruskal gamma A measure of association used when the row and column values are ordinal variables. G ...

300 Fundamentals of Statistics returned by the Pearson chi square might lead you erroneously to reject or accept the null hypoth ...

Chapter 7 Tables 301 Next you want to give the two groups descriptive names and collapse the PivotTable around the two groups yo ...

302 Fundamentals of Statistics Figure 7-23 Table statistics for the grouped PivotTable There is little difference in our conclus ...

Chapter 7 Tables 303 inherent order. For ordinal variables, there are more powerful tests than the Pearson chi square, which oft ...

304 Fundamentals of Statistics In the table you just created, Excel automatically arranges the Enroll B levels in a combination ...

Chapter 7 Tables 305 Now generate the table statistics for the new table. To generate table statistics: 1 Click Descriptive Stat ...

306 Fundamentals of Statistics It’s interesting to note that those statistics which do not assume that the data are ordinal (the ...

Chapter 7 Tables 307 there were 20 of them. As the size of the classes increases, the null hypothesis increasingly overpredicts ...