Charting Our Data: Part 24:30 with Ben Deitch
In this video we'll use our 10 minute intervals to finish creating our chart!
We've got our ten minute intervals, 0:00 now we just need to know how many runners belong to each one. 0:02 To do this, we're going to use the count if's function again. 0:05 But first, 0:09 we'll need to copy the range of finishing times to get it on the clipboard. 0:10 I'll click in here, pick the range of finishing times and use Cmd or Ctrl+C. 0:15 Then, let's start in this first cell, by typing =countifs. 0:21 And then, let's paste in the range of finishing times. 0:28 Next for the first criteria, let's make sure the finishing time is 0:31 greater than 120 minutes by adding a greater than sign in quotes. 0:36 And then concatenating that with the cell that contains 120 by using an ampersand. 0:43 So ampersand and then we want to click on the 120 over here. 0:48 Now, to finish out the interval, 0:53 we just need to make sure that their time is also less than a 130. 0:55 Let's copy our first two parameters and 1:00 paste them at the end, after adding a comma. 1:04 Then let's change the greater than sign to 1:08 a less than sign and change A16 to A17. 1:12 Then let's hit Enter, and we've got 0. 1:16 Not quite what we were expecting. 1:21 It turns out that in Google Sheets, when you see a duration like this, 1:24 behind the scenes, the units they're using are days. 1:29 So, if we want our comparisons to work, we'll need to convert our minutes to days. 1:33 To convert minutes to days, since there's 60 minutes in an hour, and 1:39 24 hours in a day, you would just divide the minutes by 60, and then 24. 1:43 Back in our equation, let's divide both A16 and 1:49 A17 by 60, and then 24. 1:54 And now it looks like we've got 2 people who finished after 2 hours, 2:03 but before 2 hours and 10 minutes. 2:08 That's more like it. 2:11 Now let's drag this formula down to the bottom to get our data. 2:13 And now that we've got all of our data, let's make a chart. 2:21 Let's put our cursor in the upper left cell, right here on finishing interval and 2:25 then while holding down Ctrl+Shift for Windows or Cmd+Shift for Mac, 2:30 hit the right arrow, and then the down arrow to select all of our data. 2:35 Then let's click on the chart icon to create the chart. 2:40 Here we finally get to see what our data looks like. 2:45 But before we get to that, there's one thing I'd like to clean up. 2:49 This chart has a legend that takes out most of the right side of the chart, 2:53 leaving us with a lot of empty space for 2:58 some information that we already have on the left. 3:01 To remove the legend inside the Chart editor, let's click on the Customize tab. 3:04 Then click on the Legend drop down and for the position let's set it to None. 3:11 Now let's close the Chart Editor and 3:18 move our chart to the top of the sheet next to the summary data. 3:20 So what do you think? 3:36 Does it look like a bell to you? 3:37 While our data is mostly normally distributed, 3:40 it does seem to have a slight skew to it. 3:42 But would you say it's a negative skew, or a positive skew? 3:45 One way to find out would be to use the skew function. 3:49 Just for fun, in any one of these cells down here, let's call the skew function 3:53 and pass in the range of finishing times. 4:00 And since that's greater than 0, it looks like we've got a positive skew. 4:11 Visualizing your data is a great way to gain insight into what's going on 4:17 without having to do a lot of work. 4:22 In the next stage we'll dive deeper into our data and 4:24 look at how typical data analysis task breaks down. 4:27
You need to sign up for Treehouse in order to download course files.Sign up