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