**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

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.

[MUSIC]
0:00

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

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

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

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

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

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

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

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

Or if you had the stats for
0:34

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

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

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

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

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

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

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

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

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

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

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

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

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

using Cmd or Ctrl + B.
1:38

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

To figure out the minimum overall time,
1:44

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

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

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

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

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

Hit Enter to select it.
2:10

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

on the first sheet.
2:16

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

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

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

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

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

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

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

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

hit Enter to calculate the minimum.
2:52

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

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

Yep, that checks out.
3:10

Now, before we calculate the max,
3:14

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

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

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

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

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

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

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

Perfect.
3:56

In the next video, we'll look at a few
ways to define the middle of our data.
3:57

You need to sign up for Treehouse in order to download course files.

Sign up