Appendix B

Pivot Table Applications

Pivot Tables—Applications in Descriptive Statistics and Data Analysis

The pivot table is one of the most powerful and easy-to-use tools in EXCEL. This application is particularly helpful in extracting large amount of useful information from a data set. Using EXCEL’s pivot table you can:

• Create cross-tabulation or break the data down by categories so that you can see the customer rating by gender, or see the total dollars spent on online orders by the day of the week, region of the country, time of the day, or a combination of these.

• Create tables of counts to display the sale of a product by brand name, or number of customers by region. You can create cross-tabulation or contingency tables to display the ...

Get Data Visualization, Volume I now with O’Reilly online learning.

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