Summarizing Data: Maximum, Minimum, Range4:02 with Ben Deitch
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