Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Start a free Basic trial
to watch this video
In this video we'll start work on charting the results of the Boston Marathon.

0:00
All right, it's finally time to see what our data looks like.

0:03
Let's start by just seeing what happens if we try to create a chart

0:07
based on the official time column.

0:10
Over on the 2017 tab, let's click in the cell S1 and

0:15
then use Ctrl+Shift+Down to select the whole column, including the header.

0:20
If you're on a Mac, use Command+Shift+Down.

0:24
Next, to create a chart, we can either open up the Insert menu and select Chart.

0:32
Or we can just click the Chart icon hidden over here in the More menu.

0:37
Once we've done that, Google Sheets will attempt to make a chart from our data.

0:42
However, it thinks our data is supposed to be the xaxis.

0:45
And it's looking for us to have a corresponding y value for each x value.

0:50
Since we only have one column of data, let's check the Aggregate column S box.

0:57
Now we see a column chart showing each finishing time along the xaxis,

1:02
and how many finishers had that time along the y.

1:06
This gives us some idea of what our data looks like.

1:09
But ultimately, it's a bit of a mess.

1:11
By only counting runners who only finished within a second of each other,

1:15
we create a really noisy chart.

1:18
And with so many labels, we can't even fit all the data.

1:22
Look, it stops at 5 hours and 58 minutes.

1:25
And if we look behind the chart, we've got finishing times well over 6 hours.

1:31
In order to graph our data appropriately,

1:33
we need to be using bigger buckets than one second.

1:37
Let's try to make this same chart, but instead of

1:39
grouping runners down to the second, let's group runners into ten minute intervals.

1:45
That way, we should be able to have much smoother looking data

1:49
as well as cut down on the number of labels.

1:52
Let's start by first deleting this graph and then jumping over to the Summary tab.

1:58
Here, let's leave a space below the last standard deviation number and

2:02
then let's add our labels.

2:04
In column A, let's write Finishing Interval.

2:10
And in column B, let's write Number of Finishers.

2:16
Then, below the Finishing Intervals label, let's type 120.

2:22
To make comparisons easy, we're going to keep everything in minutes.

2:26
So since the first place runner finished in 2 hours and 9 minutes.

2:31
The first interval we need to have is from 120 to 130 minutes.

2:36
Below our 120, let's add a 130.

2:39
Then let's select both of these cells, and

2:43
drag out our ten minute intervals all the way down to 480.

2:47
The last finisher was just shy of 8 hours.

2:56
Great, that takes care of the intervals.

2:59
Now we just need to figure out how many runners finished in

3:02
each ten minute interval, which we'll do in the next video.
You need to sign up for Treehouse in order to download course files.
Sign up