# UT Knoxville STAT 201 - Pivot Tables (38 pages)

Previewing pages 1, 2, 3, 18, 19, 36, 37, 38 of 38 page document
View Full Document

## Pivot Tables

Previewing pages 1, 2, 3, 18, 19, 36, 37, 38 of actual document.

View Full Document
View Full Document

## Pivot Tables

182 views

Pages:
38
School:
University of Tennessee
Course:
Stat 201 - Introduction to Statistics
##### Introduction to Statistics Documents
• 22 pages

• 34 pages

• 36 pages

• 44 pages

• 29 pages

• 37 pages

Unformatted text preview:

Pivot Tables And Pivot Charts Pivot Tables and Charts 0913 1 The World of Big Data Companies have the ability to collect massive amounts of data about their customers Kroger s Capital One State Farm AT T are among many companies with databases that are terabytes in size That s too big to fit on most hard drives The data has to be translated into knowledge One of the quickest and best ways to do this is to visualize the data Pivot Tables and Charts 0913 2009 Pearson Education Inc Copyright 2 What is a Pivot Table Microsoft Excel started using pivot tables in the late 90 s Pivot tables were created to take large amounts of data and give the user the ability to easily sift through the data Usage With pivot tables we can isolate variables and control for other variables Pivot tables allow us to compare one variables over different levels of another variable Pivot Tables and Charts 0913 2009 Pearson Education Inc Copyright 3 Creating a Pivot Table Any data in Excel can be used to make a pivot table but it must have the following format Data labels at the top of each column Consistent labeling of values in the column Excel will view Y Yes y and yes all differently and register them as different values If there is mislabeled data in your pivot table you can easily remove it by unchecking the label Pivot Tables and Charts 0913 2009 Pearson Education Inc Copyright 4 Creating a Pivot Table PC Step 1 Select all data in your table This can be done by hitting Control A Step 2 Create the pivot table Click insert and then pivot table Pivot Tables and Charts 0913 2009 Pearson Education Inc Copyright 5 Creating a Pivot Table Mac Step 1 Select all data in your table This can be done by hitting Command A Step 2 Create the pivot table Under Data select PivotTable Pivot Tables and Charts 0913 2009 Pearson Education Inc Copyright 6 Pivot Table Options The pivot table has four general options Report filter Allows you to remove any results from the table by label Legend Fields Inputs a

View Full Document

Unlocking...