Frequency Table Calculator

StatisticsFreeNo sign-up

Paste your data to get a frequency table with relative frequency, percent and cumulative columns, a histogram and the steps. Numbers can be grouped into classes, and words are counted as categories.

How are you entering your data?

Try an example:

Leave blank to start at the smallest value.

Display options

Frequency table30 observations, 4 classes
Total frequency (n)
30
4 classes. Class width 10, starting at 60
Total (n)
30
Smallest
65
Largest
95
Range
30
Mean
80.2
Median
80.5
Mode
85

Frequency table

Class Midpoint Tally Frequency Relative frequency Percent Cumulative frequency Cumulative relative Cumulative percent
60-69 64.5 |||| 4 0.133 13.3% 4 0.133 13.3%
70-79 74.5 |||||||| 10 0.333 33.3% 14 0.467 46.7%
80-89 84.5 ||||||||| 11 0.367 36.7% 25 0.833 83.3%
90-99 94.5 |||| 5 0.167 16.7% 30 1.000 100.0%
Total 30 1.000 100.0%

Relative frequencies are rounded for display, so a column of rounded values may not add to exactly 1. The total row shows the exact total.

Histogram of the classes
Histogram048121620Frequency60-69: frequency 4, relative 0.133470-79: frequency 10, relative 0.3331080-89: frequency 11, relative 0.3671190-99: frequency 5, relative 0.167559.569.579.589.599.5Class boundaries
Show the steps
  1. Class width = 10 (your choice).
  2. Start at 60 and add 10 for each new class: 4 classes. Class limits are whole numbers; class boundaries sit half a unit outside them.
  3. Tally each of the 30 values into its class to get the frequency f.
  4. Relative frequency = f ÷ n. For the first class that is 4 ÷ 30 = 0.133. Percent = relative frequency × 100.
  5. Cumulative frequency is a running total of f, ending at n = 30.

About the frequency table calculator

A frequency table turns a long list of numbers or answers into a short summary. Each row shows how many times a value, category or class occurs. From those counts you get relative frequency (the share of the total), percent, and cumulative totals, which answer questions like “how many scored 79 or lower?”.

Paste raw data and the calculator counts it for you, groups numbers into classes if you ask, and draws a histogram, frequency polygon and ogive. If you already have a table from a textbook, choose Value and count, or Class intervals, and it fills in the other columns.

The columns, in plain words

  • Frequency (f): how many observations fall in the row.
  • Relative frequency: f ÷ n, a number from 0 to 1.
  • Percent: relative frequency × 100.
  • Cumulative frequency: the running total of f.
  • Cumulative relative frequency and percent: the running total of the relative frequencies, ending at 1 and 100%.

How to build a grouped table by hand

  1. Find the smallest and largest values and the range (largest minus smallest).
  2. Choose how many classes you want, usually 5 to 15, and divide the range by that number.
  3. Round up to a convenient class width.
  4. Start the first class at or below the smallest value and add the width to get each next class.
  5. Tally the data into the classes, count the tallies, then work out relative and cumulative columns.

Worked example

Take the 30 test scores in the default example, grouped with width 10 starting at 60. The class 70-79 holds 10 scores, so its relative frequency is 10 ÷ 30 = 0.333 (33.3%). The classes 60-69 and 70-79 together hold 4 + 10 = 14 scores, so the cumulative frequency at 79 is 14, or 46.7%.

Practice questions

Test yourself with 6 multiple-choice questions on this topic. Choose an answer and press Submit to see if you are right and why.
Question 1 of 6
1. Relative frequency = …
Found a mistake? Let us know!
2. In the data 2, 3, 3, 5, 3, what is the frequency of 3?
Found a mistake? Let us know!
3. Cumulative frequency of a class is…
Found a mistake? Let us know!
4. If 8 of 40 students scored 90 or more, the relative frequency is…
Found a mistake? Let us know!
5. The relative frequencies of all classes add up to…
Found a mistake? Let us know!
6. With classes 0–9 and 10–19, the class width is…
Found a mistake? Let us know!

Sources

Class width and class count are matters of judgment. The automatic option follows Sturges’ rule, and you can override it at any time.

Common questions

What is a frequency table?

A frequency table lists each value, category or class of a data set next to the number of times it occurs. The counts add up to the total number of observations, n.

How do I find relative frequency?

Divide each frequency by the total. If 6 of 30 students scored in the 70s, the relative frequency of that class is 6 ÷ 30 = 0.2. Multiply by 100 to get the percent, 20%.

What is cumulative frequency?

It is a running total of the frequencies. The cumulative frequency of a class is the number of observations in that class and every class before it, so the last row always equals n.

How many classes should a frequency table have?

Between 5 and 15 classes works for most data sets. Sturges’ rule suggests k = 1 + log2(n) classes, which gives 6 classes for 30 values. Choose a class width and a starting value yourself if you want round class limits.

What is the difference between class limits and class boundaries?

Class limits are the smallest and largest values that belong to a class, such as 60 and 69. Class boundaries sit halfway between neighbouring classes, so 59.5 and 69.5. Histograms are drawn on the boundaries so the bars touch.

Can I use words instead of numbers?

Yes. Paste categories such as colors or survey answers and the calculator counts each one, lists them from most to least common and draws a bar chart. Grouping into classes only applies to numbers.

Related calculators

Embed this calculator on your site

Free to use on class pages, blogs and course pages. Copy the code below and paste it into your page:

More statistics calculators

Browse all 544 calculators

Related to This Article

What people say about "Frequency Table Calculator: Relative and Cumulative"?

No one replied yet.

Leave a Reply