Skip to content

2. Explore Data with a Pivot Table
attachment
Students can submit work

Playback Speed:
Transcript

In the last video, you made a copy of a spreadsheet with data about a pretend person’s driving habits.

In this video, you will build a pivot table to identify the user’s most frequently visited places.

The spreadsheet lists all the places the user visited in one week.

You can see: The start location, The end location, The day of the week, The drive start time, The drive end time, The distance of each trip in miles, And the duration of each trip in minutes.

To identify patterns -- such as the places most visited -- you could go through each row in the spreadsheet and count how many times they went to each place.

But this would take a lot of time, and you might make mistakes.

A spreadsheet formula would count how many times each location appears in the location columns.

But you would have to write the formula for each location, which would still take a while.

To quickly and accurately summarize data in a spreadsheet, use a pivot table.

A “pivot table” is a chart that helps you analyze data by focusing on only the information you need.

In this case, your pivot table will show each unique location in the spreadsheet and count how many times the user visited that place.

To begin, select the data you want to use.

Choose the start locations.

Create a pivot table in a new sheet.

Next, select which data to add to the rows of the pivot table.

Again, choose the start locations.

Then, total the number of times the user visited each place.

Select the locations in the “Start” column, and select “COUNT - A” to count the number of times each location appears in the column.

Great!

Now your pivot table shows each unique location in the “Start” location column and the number of times the user visited them during the week.

Resize the columns in the table so you can see the full addresses.

This pivot table enables you to make inferences about the user.

For instance, the place they visit the most is likely their home address.

Creating pivot tables also can help you efficiently summarize data so you can work with only the parts you need for a solution.

You might use pivot tables to summarize data for a class project...

Or quickly identify important sales data for your team at work.

Now that you have used a pivot table to visualize information in your spreadsheet, move on to the next video to look at the data in a different way, using Google My Maps.

Now, it’s your turn: Build a pivot table that counts the number of times each location appears in the “Start” column of your spreadsheet.

Next
Instructions
  1. Build a pivot table that contains the number of times each location appears in the Start column of your spreadsheet.