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
Before doing any data analysis, you'll want to get acquainted with your data. In this video we'll discuss the maximum, minimum, and range.

0:00
[MUSIC]

0:04
It's time to start analyzing our data.

0:07
One of the first steps in any data analysis is to summarize the data.

0:12
By summarizing the data, we give others the ability to make decisions

0:15
based on this data without needing to see the data for themselves.

0:20
Pretend you are a race organizer and you're trying to figure out

0:23
how late you'll need to have the roads closed near the finish line.

0:27
To figure that out, you could use the race results from last year,

0:31
find who came in last and then use their time.

0:34
Or if you had the stats for

0:35
the race you could just use the maximum finishing time and be done with it.

0:40
Let's look at a couple ways that we can summarize our data.

0:43
We've already talked about the maximum, which is the highest number in a set.

0:47
But we've also got minimum, for the lowest number.

0:50
And the distance between the two is called the range.

0:53
So this set has a max of eleven, a min of two and a range of nine.

0:59
Back in Google Sheets, let's create a new sheet to keep our summaries.

1:03
Click the plus sign on the bottom left to create a new sheet.

1:06
Then, let's doubleclick on the sheet's name and rename it to Summary.

1:15
Also, while we're here, let's double click on Sheet1 and rename this to 2017 as well.

1:23
Next, on the Summary tab, let's add a few labels in column A.

1:28
Let's type Min in A1, Max in A2 and Range in A3.

1:34
Then let's go ahead and bold those by highlighting the cells and

1:38
using Cmd or Ctrl + B.

1:40
All right, now let's find those values and put them in column B.

1:44
To figure out the minimum overall time,

1:46
since our list is an order, we could just take the winner's time.

1:51
But let's figuring out the shortest time by using functions.

1:54
To use a function, start with an equal sign and then start typing your function.

1:59
So in B1 let's type =, and then type min, and there we go.

2:06
That will give us the minimum value in a numeric data set.

2:10
Hit Enter to select it.

2:12
Now we need to pass in every single finishing time from the results

2:16
on the first sheet.

2:17
To do this, with Min still selected, let's switch to the first sheet

2:24
and select the first time in the official time column.

2:29
Then, if you're on Windows or

2:30
Linux, hit Ctrl + Shift + Down to select all the way to the bottom.

2:35
If you're on Mac, use Cmd + Shift + Down.

2:39
Or if you want to use the mouse, after selecting the first entry,

2:43
just scroll to the bottom and Shift+Click on the last item in column S.

2:48
Either way, once you've got all the data in column S selected,

2:52
hit Enter to calculate the minimum.

2:56
And let's double check that that's also the first time in the list.

3:01
So 2 hours, 9 minutes and 37 seconds.

3:10
Yep, that checks out.

3:14
Now, before we calculate the max,

3:16
let's first copy the range we ended up using for the min.

3:20
Let's open up B1, and copy all of this orange text.

3:28
This is the range that we're calculating the minimum of.

3:31
And by copying it we won't need to select it again for our max calculation.

3:36
So on B2, let's type, =max, hit Enter to select it.

3:43
Paste in our Range and hit Enter again to calculate the Max.

3:48
Finally for the Range, let's just set this equal to the Max minus the Min.

3:56
Perfect.

3:57
In the next video, we'll look at a few ways to define the middle of our data.
You need to sign up for Treehouse in order to download course files.
Sign up