Data Analysis with Microsoft Excel: Updated for Office 2007

275

Chapter 7

TABLES

Objectives

In this chapter you will learn to:

Create PivotTables of a single categorical variable

Create PivotCharts as column and pie charts

Relate two categorical variables with a two-way table

Apply the chi-square test to a two-way table

Compute expected values of a two-way table

Combine or eliminate small categories to get valid tests

Test for association between ordinal variables

Create a custom sort order for your workbook

▶ ▶ ▶ ▶ ▶ ▶ ▶ ▶