**Heads up!** To view this whole video, sign in with your Courses account or enroll in your free 7-day trial.
Sign In
Enroll

Preview

Start a free Courses trial

to watch this video

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