O'Reilly logo

Even You Can Learn Statistics and Analytics: An Easy to Understand Guide to Statistics and Analytics, Third Edition by David F. Stephan, David M. Levine

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix E. Advanced Techniques

ADV: Advanced How-Tos

ADV1 Using PivotTables to Create Two-Way Cross-Classification Tables

You use PivotTables 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 using the following process:

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

2. Select Insert then PivotTable.

3. In the Create PivotTable dialog box, leave the Select a table or range option selected and change, if necessary, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required