How to Calculate Cumulative Frequency Percentage in Excel (6 Ways)

Frequently, we work with numerical data in our Excel worksheet. And so, we may need to Calculate the Cumulative Frequency Percentage. The Cumulative Percentage gives us a better understanding of various datasets. Such as Sales, class performance Scores, etc. There are multiple ways to perform the task. In this article, we’ll show you all the effective and easy methods to Calculate the Cumulative Frequency Percentage in Excel.


Download Practice Workbook

Download the following workbook to practice by yourself.


Introduction to Cumulative Frequency Percentage

Usually, frequency means the number of occurrences in a certain distribution or interval. The sum of a frequency and all the frequencies in a frequency distribution until a definite class interval is known as Cumulative Frequency. We can also name it the Running Total of the frequencies. And the percentage of this frequency is called the Cumulative Frequency Percentage. This percentage will remain the same or increase across a set of responses and will reach 100% as the highest value.


6 Effective Ways to Calculate Cumulative Frequency Percentage in Excel

To illustrate, we’ll use a sample dataset as an example. For instance, we have performance Scores obtained by some students in a subject in Column B.  The Frequency of the scores in Column C. Here, we’ll determine the Cumulative Frequency first. And then, we’ll compute the Cumulative Frequency Percentage.

6 Effective Ways to Calculate Cumulative Frequency Percentage in Excel


1. Manually Calculate Cumulative Frequency Percentage in Excel with Simple Formula

In our first method, we’ll create a simple formula to get the frequency and the percentage. Therefore, follow the steps below to carry out the operation.

STEPS:

  • First, select cell D5. Here, type the formula:
=C5
  • Then, press Enter. It’ll insert the C5 cell value (1) in D5.

Manually Calculate Cumulative Frequency Percentage in Excel with Simple Formula

  • Now, choose cell D6 to type the formula:
=C6+D5
  • Next, press Enter to get the sum.
  • After that, use the AutoFill tool to complete the series. This will simply produce the Running Total of the frequencies.

Manually Calculate Cumulative Frequency Percentage in Excel with Simple Formula

  • Subsequently, select the range E5:E10. Choose Percentage from the Number section.

  • Afterward, in cell E5, type the formula:
=D5/$D$10
  • Lastly, press Enter and use AutoFill to yield Cumulative Frequency Percentage as the output.
  • In this way, you can get your desired result.

Read More: How to Calculate Cumulative Relative Frequency in Excel (4 Examples)


2. Insert Excel SUM Function for Computing Running Total Percentage

To avoid the manual addition as we did in the first method, we can use the SUM function. So, learn the following steps to perform the task.

STEPS:

  • Firstly, select cell D5 and type the formula:
=SUM($C$5:C5)
  • Next, press Enter.
  • Use AutoFill to fill the series.

Insert Excel SUM Function for Computing Running Total Percentage

  • Consequently, in cell E5, type the below formula:
=D5/$D$10
  • Then, press Enter.
  • After that, get the other Running Total Percentages using AutoFill.

Read More: How to Make a Relative Frequency Table in Excel (with Easy Steps)


3. Combine Multiple SUM Functions to Get Cumulative Percentage

However, if we want to get the Cumulative Percentage in just one step by skipping the multiple steps, go through the process below.

STEPS:

  • First of all, select cell D5 and type the formula:
=SUM($C$5:C5)/SUM($C$5:$C$10)
  • At last, press Enter. Use AutoFill for completing the rest of the series.


4. Determine Cumulative Frequency Percentage Through Histogram

Additionally, we can see the Frequency Percentages over a definite range or intervals through Histogram. In this process, we won’t exactly get the result, but we can see other important things. In the following dataset, we have set the Interval as 2. Now, follow the process.

Determine Cumulative Frequency Percentage Through Histogram

STEPS:

  • Select Data ➤ Data Analysis at first.

Determine Cumulative Frequency Percentage Through Histogram

  • As a result, the Data Analysis dialog box will pop out.
  • There, choose Histogram from the list and press OK.

Determine Cumulative Frequency Percentage Through Histogram

  • Consequently, the Histogram dialog box will appear.
  • Then, select C5:C10 as the Input Range, and D5:D10 as the Bin Range.
  • After that, check the circle for Output Range. Type $E$4 in the box beside it.
  • Again, check the box for Cumulative Percentage and Chart Output.

  • Finally, press OK.
  • Thus, it’ll return the Histogram and also the Cumulative Percentage.

Read More: How to Make a Relative Frequency Histogram in Excel (3 Examples)


5. Apply Pivot Table Feature to Calculate Cumulative Percentage

Excel provides different functions and features for performing various tasks. Pivot Table is one of such very useful features. In this method, we’ll insert a Pivot Table for calculating the Cumulative Frequency Percentage. Therefore, learn the process.

STEPS:

  • In the beginning, go to Insert ➤ Pivot Table.

Apply Pivot Table Feature to Calculate Cumulative Percentage

  • As a result, a dialog box will emerge.
  • Select B4:C10 as the Table/Range and press OK.

Apply Pivot Table Feature to Calculate Cumulative Percentage

  • Accordingly, a new worksheet will appear and you’ll see the PivotTable Fields on the side pane.
  • There, place Score in the Rows section. Place Sum of Frequency in the Values.
  • Thus, you’ll get the dataset as shown below.

Apply Pivot Table Feature to Calculate Cumulative Percentage

  • Now, select cell B3 (Sum of Frequency) and double-click on the mouse.
  • The Value Field Settings dialog box will pop out.
  • Type Cumulative Percentage in the Custom Name.
  • Under the Show Values As tab, choose % Running Total In from the drop-down list of Show values as.
  • Press OK.

  • Eventually, you’ll get the precise Cumulative Percentage values.

Read More: How to Make Frequency Distribution Table in Excel (4 Easy Ways)


6. Find Running Total from Percentage of Unit Values

Moreover, we can find the percentage of each Frequency value first. And then, add the percentages to obtain the Cumulative Percentage. So, see the steps below to carry out the operation.

STEPS:

Find Running Total from Percentage of Unit Values

  • Then, in cell D5 type the below formula:
=C5/$C$11
  • Return the value by pressing Enter.
  • Don’t forget to choose Percentage as the Number format.
  • Subsequently, use AutoFill to return the rest of the percentage values.

Find Running Total from Percentage of Unit Values

  • Now, in cell E5, input:
=D5
  • Press Enter.

  • Next, in cell E6, insert the formula:
=E5+D6
  • Complete the series by applying AutoFill.
  • Hence, you’ll get the Running Total Percentage.


Conclusion

Henceforth, follow the above-described methods. Thus, you will be able to Calculate the Cumulative Frequency Percentage in Excel. Keep using them. Let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Aung

Aung

I'm Aung. Recently I've earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo