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.

## 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. 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.

## How to Calculate Cumulative Frequency Percentage in Excel: 6 Effective Ways

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**.

### 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**.

- 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.

- 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 Do a Frequency Distribution on Excel

### 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.

- 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 Frequency Distribution Table in Excel

### 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**to completeÂ 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.

**STEPS:**

- Select
**Data âž¤ Data Analysis**at first.

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

- 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

### 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**.

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

- 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.

- 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 Create a Grouped Frequency Distribution in Excel

### 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:**

- Firstly, select cell
**C11**. Use the**AutoSum**feature to determine the**Total**of the**Frequencies**.

- 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.

- 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**.

**Download Practice Workbook**

## 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.Â Donâ€™t forget to drop comments, suggestions, or queries if you have any in the comment section below.