1 00:00:00,232 --> 00:00:03,820 All right, it's finally time to see what our data looks like. 2 00:00:03,820 --> 00:00:07,770 Let's start by just seeing what happens if we try to create a chart 3 00:00:07,770 --> 00:00:10,110 based on the official time column. 4 00:00:10,110 --> 00:00:15,160 Over on the 2017 tab, let's click in the cell S1 and 5 00:00:15,160 --> 00:00:20,800 then use Ctrl+Shift+Down to select the whole column, including the header. 6 00:00:20,800 --> 00:00:23,165 If you're on a Mac, use Command+Shift+Down. 7 00:00:24,530 --> 00:00:31,020 Next, to create a chart, we can either open up the Insert menu and select Chart. 8 00:00:32,180 --> 00:00:36,620 Or we can just click the Chart icon hidden over here in the More menu. 9 00:00:37,720 --> 00:00:42,200 Once we've done that, Google Sheets will attempt to make a chart from our data. 10 00:00:42,200 --> 00:00:45,973 However, it thinks our data is supposed to be the x-axis. 11 00:00:45,973 --> 00:00:50,590 And it's looking for us to have a corresponding y value for each x value. 12 00:00:50,590 --> 00:00:55,330 Since we only have one column of data, let's check the Aggregate column S box. 13 00:00:57,640 --> 00:01:02,110 Now we see a column chart showing each finishing time along the x-axis, 14 00:01:02,110 --> 00:01:04,960 and how many finishers had that time along the y. 15 00:01:06,060 --> 00:01:09,090 This gives us some idea of what our data looks like. 16 00:01:09,090 --> 00:01:11,920 But ultimately, it's a bit of a mess. 17 00:01:11,920 --> 00:01:15,910 By only counting runners who only finished within a second of each other, 18 00:01:15,910 --> 00:01:18,430 we create a really noisy chart. 19 00:01:18,430 --> 00:01:22,410 And with so many labels, we can't even fit all the data. 20 00:01:22,410 --> 00:01:25,850 Look, it stops at 5 hours and 58 minutes. 21 00:01:25,850 --> 00:01:29,850 And if we look behind the chart, we've got finishing times well over 6 hours. 22 00:01:31,100 --> 00:01:33,580 In order to graph our data appropriately, 23 00:01:33,580 --> 00:01:37,190 we need to be using bigger buckets than one second. 24 00:01:37,190 --> 00:01:39,930 Let's try to make this same chart, but instead of 25 00:01:39,930 --> 00:01:45,400 grouping runners down to the second, let's group runners into ten minute intervals. 26 00:01:45,400 --> 00:01:49,170 That way, we should be able to have much smoother looking data 27 00:01:49,170 --> 00:01:52,020 as well as cut down on the number of labels. 28 00:01:52,020 --> 00:01:57,550 Let's start by first deleting this graph and then jumping over to the Summary tab. 29 00:01:58,680 --> 00:02:02,910 Here, let's leave a space below the last standard deviation number and 30 00:02:02,910 --> 00:02:04,740 then let's add our labels. 31 00:02:04,740 --> 00:02:10,222 In column A, let's write Finishing Interval. 32 00:02:10,222 --> 00:02:14,500 And in column B, let's write Number of Finishers. 33 00:02:16,700 --> 00:02:22,217 Then, below the Finishing Intervals label, let's type 120. 34 00:02:22,217 --> 00:02:26,430 To make comparisons easy, we're going to keep everything in minutes. 35 00:02:26,430 --> 00:02:31,220 So since the first place runner finished in 2 hours and 9 minutes. 36 00:02:31,220 --> 00:02:36,195 The first interval we need to have is from 120 to 130 minutes. 37 00:02:36,195 --> 00:02:39,971 Below our 120, let's add a 130. 38 00:02:39,971 --> 00:02:43,029 Then let's select both of these cells, and 39 00:02:43,029 --> 00:02:47,253 drag out our ten minute intervals all the way down to 480. 40 00:02:47,253 --> 00:02:50,075 The last finisher was just shy of 8 hours. 41 00:02:56,247 --> 00:02:59,050 Great, that takes care of the intervals. 42 00:02:59,050 --> 00:03:02,140 Now we just need to figure out how many runners finished in 43 00:03:02,140 --> 00:03:05,840 each ten minute interval, which we'll do in the next video.