Home Â» How to Create a Frequency Distribution in Excel

# How to Create a Frequency Distribution in Excel

AÂ frequency distribution describes how often different values occur in a dataset. Itâ€™s a useful way to understand how data values areÂ distributedÂ in a dataset.

Fortunately itâ€™s easy to create and visualize a frequency distribution in Excel by using the following function:

=FREQUENCY(data_array, bins_array)

Â

where:

Â

• data_array: array of raw data values
• bins_array:Â array of upper limits for bins

The following example illustrates how to use this function in practice.

### Example: Frequency Distribution in Excel

Suppose we have the following dataset of 20 values in Excel:

First, we will tell Excel what upper limits weâ€™d like to use on the bins of our frequency distribution. For this example weâ€™ll choose 10, 20, and 30. That is, weâ€™ll find the frequencies for the following bins:

• 0 to 10
• 11 to 20
• 21 to 30
• 30+

Next, weâ€™ll use the following =FREQUENCY()Â function to calculate the frequencies for each bin:

=FREQUENCY(A2:A21, C2:C4)

Here are the results:

The results show that:

• 6Â values in the dataset are within the range of 0-10.
• 7 values in the dataset are within the range of 11-20.
• 5 values in the dataset are within the range of 21-30.
• 2 values in the dataset are greater than 30.

We can then use the following steps to visualize this frequency distribution:

• Highlight the frequency counts in the range D2:D5.
• Click on theÂ InsertÂ tab, then click on the chart titledÂ 2-D ColumnÂ in theÂ ChartsÂ group.

The following chart will appear that displays the frequencies for each bin:

Feel free to modify the axes labels and bar widths to make the chart more aesthetically pleasing:

You can find more Excel tutorials here.