1 00:00:00,000 --> 00:00:04,895 [MUSIC] 2 00:00:04,895 --> 00:00:07,930 It's time to start analyzing our data. 3 00:00:07,930 --> 00:00:12,110 One of the first steps in any data analysis is to summarize the data. 4 00:00:12,110 --> 00:00:15,990 By summarizing the data, we give others the ability to make decisions 5 00:00:15,990 --> 00:00:20,500 based on this data without needing to see the data for themselves. 6 00:00:20,500 --> 00:00:23,550 Pretend you are a race organizer and you're trying to figure out 7 00:00:23,550 --> 00:00:27,400 how late you'll need to have the roads closed near the finish line. 8 00:00:27,400 --> 00:00:31,100 To figure that out, you could use the race results from last year, 9 00:00:31,100 --> 00:00:34,170 find who came in last and then use their time. 10 00:00:34,170 --> 00:00:35,680 Or if you had the stats for 11 00:00:35,680 --> 00:00:40,180 the race you could just use the maximum finishing time and be done with it. 12 00:00:40,180 --> 00:00:42,710 Let's look at a couple ways that we can summarize our data. 13 00:00:43,920 --> 00:00:47,690 We've already talked about the maximum, which is the highest number in a set. 14 00:00:47,690 --> 00:00:50,430 But we've also got minimum, for the lowest number. 15 00:00:50,430 --> 00:00:53,370 And the distance between the two is called the range. 16 00:00:53,370 --> 00:00:57,770 So this set has a max of eleven, a min of two and a range of nine. 17 00:00:59,020 --> 00:01:03,140 Back in Google Sheets, let's create a new sheet to keep our summaries. 18 00:01:03,140 --> 00:01:06,558 Click the plus sign on the bottom left to create a new sheet. 19 00:01:06,558 --> 00:01:12,910 Then, let's double-click on the sheet's name and rename it to Summary. 20 00:01:15,240 --> 00:01:21,740 Also, while we're here, let's double click on Sheet1 and rename this to 2017 as well. 21 00:01:23,070 --> 00:01:26,820 Next, on the Summary tab, let's add a few labels in column A. 22 00:01:28,130 --> 00:01:34,190 Let's type Min in A1, Max in A2 and Range in A3. 23 00:01:34,190 --> 00:01:38,580 Then let's go ahead and bold those by highlighting the cells and 24 00:01:38,580 --> 00:01:40,417 using Cmd or Ctrl + B. 25 00:01:40,417 --> 00:01:44,570 All right, now let's find those values and put them in column B. 26 00:01:44,570 --> 00:01:46,696 To figure out the minimum overall time, 27 00:01:46,696 --> 00:01:51,120 since our list is an order, we could just take the winner's time. 28 00:01:51,120 --> 00:01:54,840 But let's figuring out the shortest time by using functions. 29 00:01:54,840 --> 00:01:59,240 To use a function, start with an equal sign and then start typing your function. 30 00:01:59,240 --> 00:02:06,730 So in B1 let's type =, and then type min, and there we go. 31 00:02:06,730 --> 00:02:10,480 That will give us the minimum value in a numeric data set. 32 00:02:10,480 --> 00:02:12,400 Hit Enter to select it. 33 00:02:12,400 --> 00:02:16,000 Now we need to pass in every single finishing time from the results 34 00:02:16,000 --> 00:02:17,340 on the first sheet. 35 00:02:17,340 --> 00:02:21,580 To do this, with Min still selected, let's switch to the first sheet 36 00:02:24,080 --> 00:02:27,150 and select the first time in the official time column. 37 00:02:29,170 --> 00:02:30,730 Then, if you're on Windows or 38 00:02:30,730 --> 00:02:35,970 Linux, hit Ctrl + Shift + Down to select all the way to the bottom. 39 00:02:35,970 --> 00:02:38,190 If you're on Mac, use Cmd + Shift + Down. 40 00:02:39,510 --> 00:02:43,460 Or if you want to use the mouse, after selecting the first entry, 41 00:02:43,460 --> 00:02:48,500 just scroll to the bottom and Shift+Click on the last item in column S. 42 00:02:48,500 --> 00:02:52,440 Either way, once you've got all the data in column S selected, 43 00:02:52,440 --> 00:02:54,490 hit Enter to calculate the minimum. 44 00:02:56,669 --> 00:03:00,070 And let's double check that that's also the first time in the list. 45 00:03:01,280 --> 00:03:04,380 So 2 hours, 9 minutes and 37 seconds. 46 00:03:10,167 --> 00:03:11,640 Yep, that checks out. 47 00:03:14,280 --> 00:03:16,680 Now, before we calculate the max, 48 00:03:16,680 --> 00:03:20,430 let's first copy the range we ended up using for the min. 49 00:03:20,430 --> 00:03:26,890 Let's open up B1, and copy all of this orange text. 50 00:03:28,690 --> 00:03:31,810 This is the range that we're calculating the minimum of. 51 00:03:31,810 --> 00:03:36,490 And by copying it we won't need to select it again for our max calculation. 52 00:03:36,490 --> 00:03:43,290 So on B2, let's type, =max, hit Enter to select it. 53 00:03:43,290 --> 00:03:48,490 Paste in our Range and hit Enter again to calculate the Max. 54 00:03:48,490 --> 00:03:55,330 Finally for the Range, let's just set this equal to the Max minus the Min. 55 00:03:56,500 --> 00:03:57,470 Perfect. 56 00:03:57,470 --> 00:04:01,510 In the next video, we'll look at a few ways to define the middle of our data.