DOC PREVIEW
UT Knoxville STAT 201 - Chapter 04 Z05 Pivot Tables and Charts Student 0517

This preview shows page 1-2-3-18-19-37-38-39 out of 39 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 39 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Slide 1The World of Big DataWhat is a Pivot Table?Creating a Pivot TableCreating a Pivot Table (PC)Creating a Pivot Table (Mac)Pivot Table OptionsChanging the Value DisplayedExample Pivot TableFrom Tables to ChartsCreation of Pivot ChartsDefault Pivot Chart for Previous ExampleFurther Improvements to the Pivot ChartFurther Improvements to the Pivot Chart (Cont.)Further Improvements to the Pivot Chart (Cont.)Further Improvements to the Pivot Chart (Cont.)Further Improvements to the Pivot Chart (Cont.)Further Improvements to the Pivot Chart (Cont.)Further Improvements to the Pivot Chart (Cont.)Further Improvements to the Pivot Chart (Cont.)Excel and other Microsoft ProductsData Exploration ExampleData Exploration Example (Cont.)Data Exploration Example (Cont.)Data Exploration Example (Cont.)Data Exploration Example (Cont.)Data Exploration Example (Cont.)Data Exploration Example (Cont.)Data Exploration Example (Cont.)Data Exploration Example (Cont.)“Filtering” Out the OutliersData Exploration Example (Cont.)Data Exploration Example (Cont.)Pivot Chart OptionsAssignment (to count as 2% of your overall course grade)Assignment (Continued)Assignment (Continued)Assignment (Continued)Assignment (Continued)Pivot Tables and Charts 05171Pivot TablesAndPivot ChartsCopyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 05172The World of Big DataCompanies have the ability to collect massive amounts of data about their customers.Kroger, Capital One, State Farm, AT&T are among many companies with databases that are several petabytes in size (1000 Terabytes = 1 Petabyte).That’s too big to fit on your hard drive!The data has to be translated into knowledge.One of the quickest and best ways to do this is to visualize the data.Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 05173What is a Pivot Table?Microsoft Excel developed 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.Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 05174Creating 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.Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 05175Creating 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 the INSERT tab and then Pivot TableCopyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 05176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 PivotTableCreating a Pivot Table (Mac)orNOTE: Other than this page, all of the images and instructions in this presentation are from Excel 2013 (which is a PC version of Excel)Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 05177Pivot Table OptionsThe pivot table has four general options.COLUMNS – Inputs a variable into the column.ROWS – Inputs a variable into the row.VALUES - Assigns the value that will be displayed in the table.FILTERS– Allows you to remove any results from the table that you choose.Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 05178Changing the Value DisplayedIt is important that you select the proper value to be displayed on your chart. By clicking on the value you can change it by selecting “Value Field Settings”.Sum Count Average Max or MinCopyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 05179Example Pivot TableThe pivot table at the bottom of the screen was constructed using the following:COLUMNS – Gender (q01)ROWS – Fraternity/Sorority (q14)VALUES – Average Height (q03)What do these results tell us?Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 051710From Tables to ChartsThe first thing you should do when you get data is visualize it.Pivot tables allow us to aggregate data but the real power is putting it on graphs and charts.With a click of a button you can go from a pivot table to a pivot chart.This can be found under PIVOTTABLE TOOLS – ANALYZE – Pivot ChartCopyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 051711Creation of Pivot ChartsWhatever is on your pivot table will be visualized on the pivot chart.Changes made to the pivot table update automatically on the pivot chart.There are many options to customize your pivot chart.Always try to customize your pivot chart so that what is displayed in the pivot table is clear to the person looking at it.Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 051712Default Pivot Chart for Previous ExampleCan we improve the look of this image?Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 051713Further Improvements to the Pivot ChartThere are many options to improve your pivot chart.Let’s explore some of the basic options to improve your pivot table.Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 051714Click the + symbol to the right of the Pivot Chart to reveal the Chart Elements options:A descriptive title for your Pivot Chart is a must.Further Improvements to the Pivot Chart (Cont.)Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 051715Further Improvements to the Pivot Chart (Cont.)What other improvements can we make?Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 051716Further Improvements to the Pivot Chart (Cont.)What else could we add?Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 051717Further Improvements to the Pivot Chart (Cont.)Copyright © 2009 Pearson Education, Inc. Pivot Tables and Charts 051718The images shown previously are screenshots of Pivot Charts while they are still in the Excel worksheet. Here is what the Pivot Chart from the previous slide looks like once


View Full Document

UT Knoxville STAT 201 - Chapter 04 Z05 Pivot Tables and Charts Student 0517

Documents in this Course
Chapter 8

Chapter 8

43 pages

Chapter 7

Chapter 7

30 pages

Chapter 6

Chapter 6

43 pages

Chapter 5

Chapter 5

23 pages

Chapter 3

Chapter 3

34 pages

Chapter 2

Chapter 2

18 pages

Chapter 1

Chapter 1

11 pages

Load more
Download Chapter 04 Z05 Pivot Tables and Charts Student 0517
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Chapter 04 Z05 Pivot Tables and Charts Student 0517 and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Chapter 04 Z05 Pivot Tables and Charts Student 0517 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?