How to Create a Percent Frequency Distribution in Excel


A percent frequency distribution can be used to understand what percentage of a distribution is composed of certain values.

The following step-by-step example shows how to create a percent frequency distribution in Excel.

Step 1: Create the Data

First, let’s create a dataset that contains information about 20 different basketball players:

Step 2: Calculate Frequencies

Next, we’ll use the UNIQUE() function to produce an array of unique team values in column A:

Next, we’ll use the COUNTIF() function to count the number of times each team appears:

Step 3: Convert Frequencies to Percentages

Next, we’ll convert each frequency to a percentage by dividing each individual frequency by the sum of the frequencies:

Next, we’ll highlight each of the values in column F and click the percentage (%) icon in the Number group along the top ribbon:

Each value will automatically be displayed as a percentage:

From the output we can see that:

  • 35% of all players belong to team A
  • 25% of all players belong to team B
  • 15% of all players belong to team C
  • 25% of all players belong to team D

Note that the percentages add up to 100%.

Additional Resources

The following tutorials offer additional information on how to calculate frequencies in Excel:

How to Calculate Cumulative Frequency in Excel
How to Create a Frequency Distribution in Excel
How to Make a Frequency Polygon in Excel

Leave a Reply

Your email address will not be published.