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

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