**Heads up!** To view this whole video, sign in with your Courses account or enroll in your free 7-day trial.
Sign In
Enroll

Preview

Start a free Courses trial

to watch this video

In this video we'll start work on charting the results of the Boston Marathon.

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

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

based on the official time column.
0:07

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

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

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

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

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

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

However, it thinks our data
is supposed to be the x-axis.
0:42

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

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

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

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

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

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

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

we create a really noisy chart.
1:15

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

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

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

In order to graph our data appropriately,
1:31

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

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

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

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

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

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

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

then let's add our labels.
2:02

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

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

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

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

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

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

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

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

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

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

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

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

each ten minute interval,
which we'll do in the next video.
3:02

You need to sign up for Treehouse in order to download course files.

Sign up