*57*

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