Hello, and welcome to a video on frequency tables in Excel. Today, I'll be showing
you how to make a frequency table two different ways. The first way will be using pivot tables.
So first, I'm going to select the variable that we'll use. Let's use IV2 today.
Let's scroll back up to the top. And we'll go to insert pivot table
from table range. And our range is selected here. You can see now we've got this moving
highlighted bar going around our numbers. And we wanted to be in our existing worksheet. And I'm going to click
this cell right here. Okay. So now we have an empty pivot table. And you can see
we've got fields, rows, columns, filters, values, all kinds of different options
over here for how we want to organize our pivot table. We're trying to make a frequency table.
So the first thing we want to do is move IV2 over to rows. And now you can see we get a whole row
of the different numbers that are available in IV2. We also want a running count. So we're
going to drag IV2 down again to values. Click this drop down here,
field value settings. And select count. Click OK.
Now we have the number of times this number appears in our data set.
Let's add one more row or a column, rather. Another way
we can change this is by right-clicking at the blue bar at the top. And
we're going to show values as percent running total
of IV2. And this will give us a cumulative percentage.
And that's it. That's all you need to know about frequency tables with the pivot table. Next,
we can make a frequency table using the data analysis tool pack.
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,
you'll see a little button that says data analysis. When you click on the data ribbon,
so we'll click data analysis. Okay,
and now we'll click
histogram. Sometimes this does take a moment to load.
Click OK. Now we want to select our input range, so we will go to let's do it for IV2 again.
Okay, we don't have any bins, so we will select a bin range. It'll automatically
make our bins for us. I did include the label IV2, so we'll make sure labels is clicked.
We'll click output range and put it -- we'll click here first, and then put it right here.
And we want to select cumulative percentage here. We don't want to chart this time, so we won't click chart output.
And now we'll click okay. And you can see we have bin, frequency, and cumulative percentage.
And that's it. That's all you need to know about frequency tables in Excel. Have fun!
fun!