1 00:00:00,200 --> 00:00:02,266 2 00:00:02,266 --> 00:00:08,432 Hello, and welcome to a video on frequency tables in Excel. Today, I'll be showing 3 00:00:08,433 --> 00:00:08,466 4 00:00:08,466 --> 00:00:14,099 you how to make a frequency table two different ways. The first way will be using pivot tables. 5 00:00:14,100 --> 00:00:14,800 6 00:00:14,800 --> 00:00:19,600 So first, I'm going to select the variable that we'll use. Let's use IV2 today. 7 00:00:19,600 --> 00:00:27,933 8 00:00:27,933 --> 00:00:33,366 Let's scroll back up to the top. And we'll go to insert pivot table 9 00:00:33,366 --> 00:00:34,866 10 00:00:34,866 --> 00:00:41,099 from table range. And our range is selected here. You can see now we've got this moving 11 00:00:41,100 --> 00:00:47,133 highlighted bar going around our numbers. And we wanted to be in our existing worksheet. And I'm going to click 12 00:00:47,133 --> 00:00:47,599 13 00:00:47,600 --> 00:00:53,633 this cell right here. Okay. So now we have an empty pivot table. And you can see 14 00:00:53,633 --> 00:00:59,799 we've got fields, rows, columns, filters, values, all kinds of different options 15 00:00:59,800 --> 00:00:59,833 16 00:00:59,833 --> 00:01:05,833 over here for how we want to organize our pivot table. We're trying to make a frequency table. 17 00:01:05,833 --> 00:01:05,966 18 00:01:05,966 --> 00:01:11,499 So the first thing we want to do is move IV2 over to rows. And now you can see we get a whole row 19 00:01:11,500 --> 00:01:12,133 20 00:01:12,133 --> 00:01:18,299 of the different numbers that are available in IV2. We also want a running count. So we're 21 00:01:18,300 --> 00:01:18,333 22 00:01:18,333 --> 00:01:23,733 going to drag IV2 down again to values. Click this drop down here, 23 00:01:23,733 --> 00:01:24,766 24 00:01:24,766 --> 00:01:30,699 field value settings. And select count. Click OK. 25 00:01:30,700 --> 00:01:31,533 26 00:01:31,533 --> 00:01:37,366 Now we have the number of times this number appears in our data set. 27 00:01:37,366 --> 00:01:38,132 28 00:01:38,133 --> 00:01:44,166 Let's add one more row or a column, rather. Another way 29 00:01:44,166 --> 00:01:50,166 we can change this is by right-clicking at the blue bar at the top. And 30 00:01:50,166 --> 00:01:56,532 we're going to show values as percent running total 31 00:01:56,533 --> 00:01:58,033 32 00:01:58,033 --> 00:02:02,366 of IV2. And this will give us a cumulative percentage. 33 00:02:02,366 --> 00:02:06,732 34 00:02:06,733 --> 00:02:12,699 And that's it. That's all you need to know about frequency tables with the pivot table. Next, 35 00:02:12,700 --> 00:02:12,933 36 00:02:12,933 --> 00:02:18,633 we can make a frequency table using the data analysis tool pack. 37 00:02:18,633 --> 00:02:19,466 38 00:02:19,466 --> 00:02:25,699 If you don't have the data analysis tool pack, please watch the video for how to install it. If you do have it installed, 39 00:02:25,700 --> 00:02:25,733 40 00:02:25,733 --> 00:02:29,233 you'll see a little button that says data analysis. When you click on the data ribbon, 41 00:02:29,233 --> 00:02:32,699 42 00:02:32,700 --> 00:02:34,900 so we'll click data analysis. Okay, 43 00:02:34,900 --> 00:02:51,600 44 00:02:51,600 --> 00:02:56,433 and now we'll click 45 00:02:56,433 --> 00:03:10,799 46 00:03:10,800 --> 00:03:14,700 histogram. Sometimes this does take a moment to load. 47 00:03:14,700 --> 00:03:17,233 48 00:03:17,233 --> 00:03:23,366 Click OK. Now we want to select our input range, so we will go to let's do it for IV2 again. 49 00:03:23,366 --> 00:03:28,366 50 00:03:28,366 --> 00:03:34,699 Okay, we don't have any bins, so we will select a bin range. It'll automatically 51 00:03:34,700 --> 00:03:34,733 52 00:03:34,733 --> 00:03:39,333 make our bins for us. I did include the label IV2, so we'll make sure labels is clicked. 53 00:03:39,333 --> 00:03:41,533 54 00:03:41,533 --> 00:03:47,033 We'll click output range and put it -- we'll click here first, and then put it right here. 55 00:03:47,033 --> 00:03:48,266 56 00:03:48,266 --> 00:03:54,199 And we want to select cumulative percentage here. We don't want to chart this time, so we won't click chart output. 57 00:03:54,200 --> 00:03:55,200 58 00:03:55,200 --> 00:04:01,300 And now we'll click okay. And you can see we have bin, frequency, and cumulative percentage. 59 00:04:01,300 --> 00:04:08,000 60 00:04:08,000 --> 00:04:13,533 And that's it. That's all you need to know about frequency tables in Excel. Have fun! 61 00:04:13,533 --> 00:04:18,666 62 00:04:18,666 --> 00:04:19,599 fun!