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.