Already have a frequency table? Turn it into a histogram without recreating the raw data. Enter each class and its count, and the maker draws the bars and calculates the relative and cumulative frequency columns — then switch the Y-axis to percentages with one click.
A frequency histogram shows raw counts: how many values fall in each class. A relative frequency histogram shows the same bars but converts each count to a share of the total, normally a percentage. The shape is identical — only the Y-axis changes — but relative frequency lets you compare two datasets of different sizes on equal footing.
To find relative frequency, divide each class count by the total number of values. The example below uses 31 values across five classes.
| Class | Frequency | Relative % | Cumulative % |
|---|---|---|---|
| 0 – 10 | 3 | 9.7% | 9.7% |
| 10 – 20 | 8 | 25.8% | 35.5% |
| 20 – 30 | 12 | 38.7% | 74.2% |
| 30 – 40 | 6 | 19.4% | 93.5% |
| 40 – 50 | 2 | 6.5% | 100% |
| Total | 31 | 100% | — |
You do not need the original raw numbers. In the maker, switch to Frequency table mode and type one class per line:
0-10, 3 then 10-20, 8, one class per row.Working the other way — from raw data to a frequency table — is just as easy: paste your numbers in Raw data mode and the maker generates the frequency, relative and cumulative columns for you.
Cumulative frequency answers a different question: “how many values fall at or below this point?” You build it by adding each class to the running total, so the final class always reaches the full count (and 100% in relative terms). Plotting cumulative relative frequency against the upper class boundaries produces an ogive, an S-shaped curve that makes medians and percentiles easy to read off by eye. The maker calculates the cumulative column automatically and includes it in the CSV export, so you have the numbers ready whether you need a histogram or an ogive.
Reach for a relative frequency histogram whenever the totals differ. If one class has 40 students and another has 120, raw counts make the larger class look dominant even when the shape of the two distributions is identical. Converting to percentages puts them on the same footing. Relative frequency is also the natural bridge to probability: the proportion in each bin estimates how likely a new value is to land there.
If your classes are not all the same width, comparing bar heights directly is misleading, because a wider bar covers more of the number line. The fix is frequency density — divide each frequency by its class width and plot that on the Y-axis. With equal-width classes this is unnecessary, which is why most everyday histograms simply use counts.
If your frequency table lives in Excel or Google Sheets, you can chart it there too. In Excel, use the FREQUENCY function and a column chart with zero gap width. In Google Sheets, the histogram chart type bins raw data directly. For anything more than a quick chart, the maker above is faster and adds the statistics automatically.
A frequency histogram groups numbers into classes (bins) and draws a bar for each class whose height is the count of values inside it. It answers "how many data points fall in each range?"
Frequency is a raw count. Relative frequency is that count divided by the total, usually shown as a percentage. A relative frequency histogram has the same bars but a percentage Y-axis, which makes datasets of different sizes comparable.
Open the tool, switch to Frequency table mode, and enter one class per line as range, count — for example 20-30, 12. The maker draws the bars and builds the relative and cumulative columns for you.
Divide each class frequency by the total number of values. For a class with 12 items in a dataset of 50, the relative frequency is 12 ÷ 50 = 0.24, or 24%.