Appendix E. Advanced Techniques

E.1 Using PivotTables to Create Two-Way Cross-Classification Tables

You use PivotTables (called DataPilots in Calc 3) to create two-way cross-classification tables from your data values. PivotTables are worksheet areas that act as if you had entered formulas to summarize data. PivotTables give you the ability to drill down, or look at, the unsummarized data values from which the summary information is derived.

You create a PivotTable by dragging variable names into a PivotTable form or template. The process varies depending on whether you use Excel 97–2003, Excel 2007 or later, or Calc 3.

For Excel 97–2003:

  1. Open to the worksheet that contains your unsummarized data. ...

Get Math for the Non-Math Lovers (Collection) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.