We've got our ten minute intervals,

now we just need to know how many runners belong to each one.

To do this, we're going to use the count if's function again.

But first,

we'll need to copy the range of finishing times to get it on the clipboard.

I'll click in here, pick the range of finishing times and use Cmd or Ctrl+C.

Then, let's start in this first cell, by typing =countifs.

And then, let's paste in the range of finishing times.

Next for the first criteria, let's make sure the finishing time is

greater than 120 minutes by adding a greater than sign in quotes.

And then concatenating that with the cell that contains 120 by using an ampersand.

So ampersand and then we want to click on the 120 over here.

Now, to finish out the interval,

we just need to make sure that their time is also less than a 130.

Let's copy our first two parameters and

paste them at the end, after adding a comma.

Then let's change the greater than sign to

a less than sign and change A16 to A17.

Then let's hit Enter, and we've got 0.

Not quite what we were expecting.

It turns out that in Google Sheets, when you see a duration like this,

behind the scenes, the units they're using are days.

So, if we want our comparisons to work, we'll need to convert our minutes to days.

To convert minutes to days, since there's 60 minutes in an hour, and

24 hours in a day, you would just divide the minutes by 60, and then 24.

Back in our equation, let's divide both A16 and

A17 by 60, and then 24.

And now it looks like we've got 2 people who finished after 2 hours,

but before 2 hours and 10 minutes.

That's more like it.

Now let's drag this formula down to the bottom to get our data.

And now that we've got all of our data, let's make a chart.

Let's put our cursor in the upper left cell, right here on finishing interval and

then while holding down Ctrl+Shift for Windows or Cmd+Shift for Mac,

hit the right arrow, and then the down arrow to select all of our data.

Then let's click on the chart icon to create the chart.

Here we finally get to see what our data looks like.

But before we get to that, there's one thing I'd like to clean up.

This chart has a legend that takes out most of the right side of the chart,

leaving us with a lot of empty space for

some information that we already have on the left.

To remove the legend inside the Chart editor, let's click on the Customize tab.

Then click on the Legend drop down and for the position let's set it to None.

Now let's close the Chart Editor and

move our chart to the top of the sheet next to the summary data.

So what do you think?

Does it look like a bell to you?

While our data is mostly normally distributed,

it does seem to have a slight skew to it.

But would you say it's a negative skew, or a positive skew?

One way to find out would be to use the skew function.

Just for fun, in any one of these cells down here, let's call the skew function

and pass in the range of finishing times.

And since that's greater than 0, it looks like we've got a positive skew.

Visualizing your data is a great way to gain insight into what's going on

without having to do a lot of work.

In the next stage we'll dive deeper into our data and

look at how typical data analysis task breaks down.