Statistics How To

Frequency Distribution Table: Examples, How to Make One

“>
Contents (Click to skip to that section):

See also: Frequency Distribution Table in Excel

What is a Frequency Distribution Table?

Frequency tells you how often something happened. The frequency of an observation tells you the number of times the observation occurs in the data. For example, in the following list of numbers, the frequency of the number 9 is 5 (because it occurs 5 times):

1, 2, 3, 4, 6, 9, 9, 8, 5, 1, 1, 9, 9, 0, 6, 9.

Tables can show either categorical variables (sometimes called qualitative variables) or quantitative variables (sometimes called numeric variables). You can think of categorical variables as categories (like eye color or brand of dog food) and quantitative variables as numbers.

If you aren’t quite sure of the difference, see: Qualitative or quantitative? How to tell.

The following table shows what family planning methods were used by teens in Kweneng, West Botswana. The left column shows the categorical variable (Method) and the right column is the frequency — the number of teens using that particular method (image courtesy of KSU).

A frequency distribution table showing categorical variables.

A frequency distribution table showing categorical variables.

Frequency distribution tables give you a snapshot of the data to allow you to find patterns. A quick look at the above frequency distribution table tells you the majority of teens don’t use any birth control at all.

Back to Top

How to make a Frequency Distribution Table: Examples

Example 1

Tally marks are often used to make a frequency distribution table. For example, let’s say you survey a number of households and find out how many pets they own. The results are 3, 0, 1, 4, 4, 1, 2, 0, 2, 2, 0, 2, 0, 1, 3, 1, 2, 1, 1, 3. Looking at that string of numbers boggles the eye; a frequency distribution table will make the data easier to understand.

Steps

To make the frequency distribution table, first write the categories in one column (number of pets):
frequency distribution table 3

Next, tally the numbers in each category (from the results above). For example, the number zero appears four times in the list, so put four tally marks “||||”:
frequency distribution table 2

Finally, count up the tally marks and write the frequency in the final column. The frequency is just the total. You have four tally marks for “0”, so put 4 in the last column:
frequency distribution table
Back to Top

Example 2

Watch the video or read the steps below:

How to Draw a Frequency Distribution Table (Slightly More Complicated Example)

A frequency distribution table is one way you can organize data so that it makes more sense. For example, let’s say you have a list of IQ scores for a gifted classroom in a particular elementary school. The IQ scores are: 118, 123, 124, 125, 127, 128, 129, 130, 130, 133, 136, 138, 141, 142, 149, 150, 154. That list doesn’t tell you much about anything. You could draw a frequency distribution table, which will give a better picture of your data than a simple list.

How to Draw a Frequency Distribution Table: Steps.

Part 1: Choosing Classes

Step 1: Figure out how many classes (categories) you need. There are no hard rules about how many classes to pick, but there are a couple of general guidelines:

  • Pick between 5 and 20 classes. For the list of IQs above, we picked 5 classes.
  • Make sure you have a few items in each category. For example, if you have 20 items, choose 5 classes (4 items per category), not 20 classes (which would give you only 1 item per category).

Note: There is a more mathematical way to choose classes. The formula is log(observations)\ log(2). You would round up the answer to the next integer. For example, log17\log2 = 4.1 will be rounded up to become 5. (Thank you to Ayman Masry for that tip).


Part 2: Sorting the Data

Step 2: Subtract the minimum data value from the maximum data value. For example, our IQ list above had a minimum value of 118 and a maximum value of 154, so:
154 – 118 = 36

Step 3: Divide your answer in Step 2 by the number of classes you chose in Step 1.
36 / 5 = 7.2

Step 4: Round the number from Step 3 up to a whole number to get the class width. Rounded up, 7.2 becomes 8.

Step 5: Write down your lowest value for your first minimum data value:
The lowest value is 118

Step 6: Add the class width from Step 4 to Step 5 to get the next lower class limit:
118 + 8 = 126

Step 7: Repeat Step 6 for the other minimum data values (in other words, keep on adding your class width to your minimum data values) until you have created the number of classes you chose in Step 1. We chose 5 classes, so our 5 minimum data values are:
118
126 (118 + 8)
134 (126 + 8)
142 (134 + 8)
150 (142 + 8)

Step 8: Write down the upper class limits. These are the highest values that can be in the category, so in most cases you can subtract 1 from the class width and add that to the minimum data value. For example:
118 + (8 – 1) = 125
118 – 125
126 – 133
134 – 141
142 – 149
150 – 157

3. Finishing the Table Up

Step 9: Add a second column for the number of items in each class, and label the columns with appropriate headings:

IQ Number
118-125
126-133
134-141
142-149
150-157

Step 10: Count the number of items in each class, and put the total in the second column. The list of IQ scores are: 118, 123, 124, 125, 127, 128, 129, 130, 130, 133, 136, 138, 141, 142, 149, 150, 154.

IQ Number
118-125 4
126-133 6
134-141 3
142-149 2
150-157 2

That’s How to Draw a Frequency Distribution Table, the easy way!

Like the explanation? Check out our statistics how-to book, with hundreds more step by step solutions, just like this one!

Tip: If you are working with large numbers (like hundreds or thousands), round Step 4 up to a large whole number that’s easy to make into classes, like 100, 1000, or 10,000. Likewise with very small numbers — you may want to round to 0.1, 0.001 or a similar division.

Back to Top

Frequency Distribution Table: Examples, How to Make One was last modified: June 7th, 2018 by Stephanie