Cumulative percentage tells you what proportion of your total data falls at or below a given point. The formula is straightforward: divide the cumulative frequency by the total number of observations, then multiply by 100. The real skill is setting up the intermediate steps correctly, so let’s walk through the full process from raw data to finished calculation.
The Core Formula
Cumulative percentage builds on two simpler concepts: frequency and cumulative frequency. Frequency is just the count of observations in each category or interval. Cumulative frequency is a running total of those counts, where each row adds its frequency to the sum of all previous rows. Once you have cumulative frequency, the conversion to cumulative percentage is one step:
Cumulative percentage = (cumulative frequency ÷ total observations) × 100
The last value in your cumulative percentage column will always equal 100%, since by that point every observation has been counted.
Step-by-Step Calculation by Hand
Suppose you surveyed 25 people about how many hours per week they exercise, and you grouped the results into intervals: 0–2 hours (8 people), 3–5 hours (10 people), 6–8 hours (5 people), and 9–11 hours (2 people). Here’s how to build your table.
Step 1: List your categories and frequencies. Write each interval alongside its count. Confirm the frequencies add up to your total (8 + 10 + 5 + 2 = 25).
Step 2: Calculate cumulative frequency. For the first row, cumulative frequency equals the frequency itself (8). For each subsequent row, add that row’s frequency to the cumulative frequency from the row above. So the second row is 8 + 10 = 18, the third is 18 + 5 = 23, and the fourth is 23 + 2 = 25. The final cumulative frequency should match your total observations.
Step 3: Convert to cumulative percentage. Divide each cumulative frequency by the total (25) and multiply by 100. The first row becomes (8 ÷ 25) × 100 = 32%. The second row: (18 ÷ 25) × 100 = 72%. Third: (23 ÷ 25) × 100 = 92%. Fourth: (25 ÷ 25) × 100 = 100%.
Reading the results, you can now say that 72% of respondents exercise five hours or fewer per week, and 92% exercise eight hours or fewer.
How It Differs From Relative Frequency
Relative frequency and cumulative percentage answer different questions. Relative frequency tells you the percentage of observations in one specific category. In the example above, the relative frequency for the 3–5 hours group is (10 ÷ 25) × 100 = 40%. That means 40% of respondents fell into that single interval.
Cumulative percentage, on the other hand, tells you the percentage at or below a given interval. The cumulative percentage for 3–5 hours is 72%, because it includes both the 0–2 group and the 3–5 group. If you only need to know how a single category compares to the whole, use relative frequency. If you need to know what share of data falls up to a certain threshold, cumulative percentage is what you want.
Calculating Cumulative Percentage in a Spreadsheet
You can automate the entire process in Excel or Google Sheets with a few formulas. Assume your categories are in column A, your frequencies are in column B starting at B2, and you’ll build cumulative frequency in column C and cumulative percentage in column D.
Cumulative frequency column (C): In cell C2, enter the formula =SUM($B$2:B2). The first cell reference is locked with dollar signs (an absolute reference), while the second uses only a column lock. When you drag this formula down, each new row expands the range by one, creating a running total. So C3 becomes =SUM($B$2:B3), C4 becomes =SUM($B$2:B4), and so on.
Cumulative percentage column (D): In cell D2, enter =C2/SUM($B$2:$B$100)*100, replacing $B$100 with the last row of your actual data. This divides each cumulative frequency by the fixed total and converts it to a percentage. Drag the formula down to fill the rest of the column. If you prefer, you can put the total in a separate cell and reference that cell instead of recalculating the sum each time.
Format column D as a number with one or two decimal places, or apply percentage formatting (in which case remove the “×100” from your formula, since the format handles it). The last row should read exactly 100%.
Using Cumulative Percentage in Pareto Analysis
One of the most common real-world applications of cumulative percentage is Pareto analysis, which is built around the 80/20 rule: roughly 80% of outcomes stem from 20% of causes. Quality control teams, customer service departments, and project managers use this to figure out where to focus their effort.
To run a Pareto analysis, start by ranking your categories from largest to smallest by frequency or value. Calculate each category’s individual percentage of the total, then build the cumulative percentage column the same way described above. The first category’s cumulative percentage equals its individual percentage. Each subsequent category adds its own percentage to the running total.
Plot the results as a Pareto chart: bars for individual percentages (sorted from tallest to shortest) on the left axis, and a line for cumulative percentage on the right axis. The right axis runs from 0% to 100%. Where the cumulative percentage line crosses 80%, draw a horizontal line down to the category axis. Everything to the left of that point represents the “vital few” causes responsible for most of the effect. If you’re tracking customer complaints, for instance, the categories to the left of the 80% line are the complaint types that, if resolved, would eliminate the bulk of your issues.
Tips for Accurate Results
Double-check that your frequencies add up to the actual total before dividing. A miscount in even one category will throw off every cumulative percentage from that row forward. The simplest check: your final cumulative frequency must equal the total number of observations, and your final cumulative percentage must equal exactly 100%.
When working with grouped data (intervals like 0–10, 11–20), make sure the intervals don’t overlap and don’t leave gaps. If someone scores exactly 10, they need to fall into one interval, not two. Overlapping bins inflate your total and produce cumulative percentages that exceed 100%.
If your data has ties or categories with zero observations, include those rows anyway. A zero frequency doesn’t change the cumulative total, but skipping the row can make your table harder to read and your chart misleading. Keeping every category visible ensures readers can see the full distribution at a glance.