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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
