How do you make a grouped frequency table?

Choose a class width, start the first class at or below the smallest value, and count how many values fall in each class. Each class includes its lower limit but not its upper limit, so every value is counted exactly once.

What is relative frequency?

Relative frequency is a class’s count divided by the total number of values, usually shown as a percentage. The relative frequencies of all classes add up to 100%.

What is cumulative frequency?

Cumulative frequency is the running total: the number of values in this class and every class before it. The last class’s cumulative frequency equals the total number of values.

Frequency Table Maker

Paste raw data, get a grouped frequency table: frequency, relative frequency and cumulative frequency, with its histogram. Free, no sign-up.

Start from

Graph title

Category axis title

Value axis title

Paste from a spreadsheet or CSV

Pasted data

First column: the labels. Each further column is a series (more than one makes a double or stacked bar graph). Copy cells straight from Excel or Google Sheets, or paste CSV. A header row names the series. You can also paste into any cell of the table.

Style

Direction

Order

Bar colours

Colour

Bar height

Background

Value labels Gridlines

Reading a grouped frequency table

Frequency is how many values fall in each class (bin). Relative frequency is that count as a percentage of all values; rounded here so the column adds up to exactly 100%. Cumulative frequency is the running total, so the last row equals the number of values. Cumulative percent answers questions like “what share scored under 80?” in one look.

Class width and limits

Set Bin width to choose the class width and First bin starts at to choose the first lower limit. Each class includes its lower limit and not its upper one (150–155 holds 150 up to, but not including, 155), so no value is counted twice. Use Copy table as CSV to take the table into Excel or Google Sheets.