1 00:00:00,210 --> 00:00:02,150 We've got our ten minute intervals, 2 00:00:02,150 --> 00:00:05,950 now we just need to know how many runners belong to each one. 3 00:00:05,950 --> 00:00:09,290 To do this, we're going to use the count if's function again. 4 00:00:09,290 --> 00:00:10,120 But first, 5 00:00:10,120 --> 00:00:13,850 we'll need to copy the range of finishing times to get it on the clipboard. 6 00:00:15,150 --> 00:00:20,320 I'll click in here, pick the range of finishing times and use Cmd or Ctrl+C. 7 00:00:21,460 --> 00:00:28,333 Then, let's start in this first cell, by typing =countifs. 8 00:00:28,333 --> 00:00:31,444 And then, let's paste in the range of finishing times. 9 00:00:31,444 --> 00:00:36,031 Next for the first criteria, let's make sure the finishing time is 10 00:00:36,031 --> 00:00:40,709 greater than 120 minutes by adding a greater than sign in quotes. 11 00:00:43,450 --> 00:00:48,990 And then concatenating that with the cell that contains 120 by using an ampersand. 12 00:00:48,990 --> 00:00:53,490 So ampersand and then we want to click on the 120 over here. 13 00:00:53,490 --> 00:00:55,320 Now, to finish out the interval, 14 00:00:55,320 --> 00:01:00,040 we just need to make sure that their time is also less than a 130. 15 00:01:00,040 --> 00:01:04,025 Let's copy our first two parameters and 16 00:01:04,025 --> 00:01:06,920 paste them at the end, after adding a comma. 17 00:01:08,020 --> 00:01:12,434 Then let's change the greater than sign to 18 00:01:12,434 --> 00:01:16,856 a less than sign and change A16 to A17. 19 00:01:16,856 --> 00:01:21,655 Then let's hit Enter, and we've got 0. 20 00:01:21,655 --> 00:01:24,310 Not quite what we were expecting. 21 00:01:24,310 --> 00:01:29,800 It turns out that in Google Sheets, when you see a duration like this, 22 00:01:29,800 --> 00:01:33,540 behind the scenes, the units they're using are days. 23 00:01:33,540 --> 00:01:39,220 So, if we want our comparisons to work, we'll need to convert our minutes to days. 24 00:01:39,220 --> 00:01:43,280 To convert minutes to days, since there's 60 minutes in an hour, and 25 00:01:43,280 --> 00:01:49,090 24 hours in a day, you would just divide the minutes by 60, and then 24. 26 00:01:49,090 --> 00:01:54,025 Back in our equation, let's divide both A16 and 27 00:01:54,025 --> 00:01:57,017 A17 by 60, and then 24. 28 00:02:03,418 --> 00:02:08,636 And now it looks like we've got 2 people who finished after 2 hours, 29 00:02:08,636 --> 00:02:11,840 but before 2 hours and 10 minutes. 30 00:02:11,840 --> 00:02:13,300 That's more like it. 31 00:02:13,300 --> 00:02:16,856 Now let's drag this formula down to the bottom to get our data. 32 00:02:21,556 --> 00:02:25,400 And now that we've got all of our data, let's make a chart. 33 00:02:25,400 --> 00:02:30,931 Let's put our cursor in the upper left cell, right here on finishing interval and 34 00:02:30,931 --> 00:02:35,823 then while holding down Ctrl+Shift for Windows or Cmd+Shift for Mac, 35 00:02:35,823 --> 00:02:40,576 hit the right arrow, and then the down arrow to select all of our data. 36 00:02:40,576 --> 00:02:45,920 Then let's click on the chart icon to create the chart. 37 00:02:45,920 --> 00:02:49,330 Here we finally get to see what our data looks like. 38 00:02:49,330 --> 00:02:53,650 But before we get to that, there's one thing I'd like to clean up. 39 00:02:53,650 --> 00:02:58,390 This chart has a legend that takes out most of the right side of the chart, 40 00:02:58,390 --> 00:03:01,120 leaving us with a lot of empty space for 41 00:03:01,120 --> 00:03:04,860 some information that we already have on the left. 42 00:03:04,860 --> 00:03:09,760 To remove the legend inside the Chart editor, let's click on the Customize tab. 43 00:03:11,150 --> 00:03:16,890 Then click on the Legend drop down and for the position let's set it to None. 44 00:03:18,460 --> 00:03:20,774 Now let's close the Chart Editor and 45 00:03:20,774 --> 00:03:24,666 move our chart to the top of the sheet next to the summary data. 46 00:03:36,046 --> 00:03:37,086 So what do you think? 47 00:03:37,086 --> 00:03:38,720 Does it look like a bell to you? 48 00:03:40,010 --> 00:03:42,910 While our data is mostly normally distributed, 49 00:03:42,910 --> 00:03:45,740 it does seem to have a slight skew to it. 50 00:03:45,740 --> 00:03:49,530 But would you say it's a negative skew, or a positive skew? 51 00:03:49,530 --> 00:03:53,250 One way to find out would be to use the skew function. 52 00:03:53,250 --> 00:03:58,240 Just for fun, in any one of these cells down here, let's call the skew function 53 00:04:00,990 --> 00:04:03,080 and pass in the range of finishing times. 54 00:04:11,570 --> 00:04:15,660 And since that's greater than 0, it looks like we've got a positive skew. 55 00:04:17,910 --> 00:04:22,050 Visualizing your data is a great way to gain insight into what's going on 56 00:04:22,050 --> 00:04:24,020 without having to do a lot of work. 57 00:04:24,020 --> 00:04:27,040 In the next stage we'll dive deeper into our data and 58 00:04:27,040 --> 00:04:29,960 look at how typical data analysis task breaks down.