Cumulative Frequency Calculator: Find CF & Percentile

A cumulative frequency calculator takes a set of values and their individual frequencies, then adds each frequency to the total of all previous ones to show how many observations fall at or below each value. You enter your data points and their counts, and the calculator returns the running total (cumulative frequency) plus the relative cumulative frequency as a percentage, which lets you quickly read percentiles and quartiles from your data. The tool below works for any grouped or ungrouped frequency table, so you can use it for test scores, production counts, or survey responses.

Formula

The cumulative frequency at a given value is the sum of all frequencies up to and including that value. Written in symbols:

CF_i = f₁ + f₂ + … + f_i

Where:

• CF_i = cumulative frequency at the i-th value (count, no unit)
• f₁, f₂, … f_i = individual frequencies for each value (count, no unit)

The relative cumulative frequency (percent) is simply the cumulative frequency divided by the total number of observations, multiplied by 100:

Cumulative percent = (CF_i / N) × 100

where N is the sum of all frequencies. If you have 100 total observations and the cumulative frequency at a value is 65, then 65% of your data lies at or below that value.

Worked Example

Suppose you have a small dataset with values 10, 20, 30 and frequencies 5, 8, 7. The total number of observations is 5 + 8 + 7 = 20.

1. For value 10: cumulative frequency = 5 (just the first frequency). Cumulative percent = 5/20 × 100 = 25%.
2. For value 20: cumulative frequency = 5 + 8 = 13. Cumulative percent = 13/20 × 100 = 65%.
3. For value 30: cumulative frequency = 5 + 8 + 7 = 20. Cumulative percent = 20/20 × 100 = 100%.

So the final cumulative frequency always equals the total count (20), and the final cumulative percent is always 100%. The calculator above with default values (value 10, frequency 5) gives a cumulative frequency of 5 and 100% because there is only one row; add more rows to see the running totals.

When to Use Cumulative Frequency

Cumulative frequency is most useful when you need to know how many observations fall below a threshold, rather than how many fall in each exact category. Common situations include:

• Finding the median: locate the value where cumulative frequency reaches half the total.
• Finding quartiles: locate values at 25%, 50%, and 75% of the total.
• Answering questions like “how many students scored 70 or below?â€� or “how many days had rainfall under 5 mm?â€�
• Creating an ogive (cumulative frequency graph) to visualize the distribution.

Unlike a plain frequency table, cumulative frequency gives you a running total, so you can immediately see the proportion of data at any cutoff point without adding several rows manually.

How to Read the Result

The output has two columns: cumulative frequency (a raw count) and cumulative percent (a proportion of the total). If your cumulative percent at a value is 80%, that means 80% of your observations are less than or equal to that value, and 20% are greater. This is the same as saying that value is the 80th percentile. To find the median, look for the value where the cumulative percent reaches or crosses 50%. For the first quartile, look for 25%; for the third quartile, 75%.

Be careful with grouped data. If your values are class intervals (like 0–10, 10–20), the cumulative frequency at the upper boundary of each interval is what you want. The calculator above expects a single representative value per row, so for intervals you should enter the upper limit of each class to get the correct cumulative total.

Common Mistakes and Unit Mix-Ups

The most frequent error is forgetting to sort your values in ascending order before calculating cumulative frequency. If you enter rows out of order, the running total becomes meaningless because it no longer represents “at or below� a value. Always list values from smallest to largest.

A second mistake is confusing frequency with cumulative frequency. The frequency column shows how many times a single value occurs; the cumulative frequency column shows the total up to that point. They are equal only for the first row.

Unit mistakes are rare here because frequencies are pure counts, but if your values have units (like kilograms or dollars), the cumulative frequency still has no unit—it is a count of observations, not a sum of the values themselves. Do not add the values together; add only their frequencies.

Limits of the Formula

Cumulative frequency works only for ordinal or quantitative data where “at or below� has a clear meaning. It is not appropriate for nominal categories like eye color or brand names, because there is no natural order. For those, you would use a simple frequency table instead.

The formula also assumes your frequency table is complete—that every observation appears in exactly one row. If you have missing data or overlapping intervals, the cumulative totals will be wrong. For grouped data, the cumulative frequency only tells you the count at the interval boundary, not the exact position within the interval; to estimate the median within an interval you would need interpolation.

Finally, the calculator above computes cumulative frequency for a single row at a time. To get a full cumulative frequency table, you must run it for each row in order, or manually add the running total yourself. The formula is simple enough to do by hand for small datasets, but the calculator helps avoid arithmetic errors when frequencies are large.

Frequently Asked Questions

How do I calculate cumulative frequency from a raw data list?

First, sort your raw data from smallest to largest. Then count how many times each distinct value appears (that is the frequency). Finally, add each frequency to the sum of all previous frequencies. For example, raw data 2, 2, 3, 5, 5, 5 gives frequencies 2 (for value 2), 1 (for value 3), and 3 (for value 5). Cumulative frequencies are 2, 3, and 6.

What is the difference between cumulative frequency and relative frequency?

Relative frequency is a single row’s frequency divided by the total number of observations, expressed as a fraction or percent. Cumulative frequency is the running total of frequencies up to a point. Relative cumulative frequency combines both: it is the cumulative frequency divided by the total, showing the percentage of data at or below a value.

Can cumulative frequency be used for percentages directly?

Yes, if you multiply the cumulative frequency by 100 and divide by the total count, you get the cumulative percentage. This is often called the percentile rank. For example, if 45 out of 60 students scored 80 or below, the cumulative percent is (45/60) × 100 = 75%, meaning a score of 80 is the 75th percentile.

Why does my last cumulative frequency not equal my total?

It should always equal the total number of observations if your frequency table is complete and correctly ordered. If it does not, you likely missed a row, entered a frequency incorrectly, or left out some data. Double-check that the sum of all individual frequencies matches your actual dataset size.

How do I find the median using cumulative frequency?

Calculate the total number of observations N. The median is the value where the cumulative frequency first reaches or exceeds N/2. If N is even, the median is often taken as the average of the two middle values; in a cumulative frequency table, you locate the interval containing N/2 and, if needed, use interpolation within that interval for grouped data.

What is an ogive and how is it related?

An ogive is a line graph that plots cumulative frequency (or cumulative percent) on the vertical axis against the upper class boundaries on the horizontal axis. It rises from 0 to the total count, and its shape lets you visually estimate the median, quartiles, and percentiles. The calculator’s cumulative percent output is exactly what you would plot on an ogive’s vertical axis.

Related

• Beat Frequency Calculator: Formula & Examples
• Belt Frequency Calculator: How It Works
• Bearing Fault Frequency Calculator: How to Use It

in v | Value | - | 10 | 0
in f | Frequency | - | 5 | 0
out cf | Cumulative frequency | - | f | 2
out p | Cumulative percent | % | (f / sum(f)) * 100 | 2