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.
This video doesn't have any notes.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
[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 upYou need to sign up for Treehouse in order to set up Workspace
Sign up