# How To Do Frequency Distribution in Excel

In Excel, a frequency distribution table tells you how the data in your spreadsheet is distributed. This frequency distribution table is sometimes used in conjunction with a histogram to further visualize the data.

## Frequency formula in Excel

In order to create an accurate frequency distribution table, you’ll need to use the FREQUENCY formula. This function has two arguments:

• Data array: Used to count the frequencies. If the data array values are zero, for example, Null values, then the frequency function will return an array of zero values.
• BIN array: Used to group the values in the data array. If the BIN array values are zero, then it will return the number of array elements from the data array.

You’ll need to use these array values in order to determine the frequency distribution of your data. Let’s continue with the process.

## Create a frequency distribution table in Excel

Use our guide to learn the basics of creating a frequency distribution table in Microsoft Excel. The process is simple and beginner-friendly. Have any questions? Don’t hesitate to contact us.

For this example, we’ll create a distribution table using employee scores. Let’s get right into it.

1. Open Microsoft Excel and select a workbook, or create a new one.
2. Make sure that there’s data present in your worksheet before continuing with the guide. Your data should be put into columns, with column headers. For example:

3. Type the upper levels for your BINs into another column. These values should be specified in increasing order and correspond to non-overlapping numeric ranges.
4. Optionally, in a third column, create labels that specify which BINs the upper limits are for.

5. Switch to the Data tab in the ribbon header interface, and then click on Data Analysis from the Analysis group.

6. If you don’t have this option, navigate to FileOptionsAdd-ins and click on the Go button. Select Analysis ToolPak and click OK. The option should appear on your ribbon now.

7. In the pop-up window, scroll down and select Histogram. Click the OK button to proceed.

• In the Input range field, specify where your data is. For this example problem, we’ll type in \$A\$2:\$A\$9
• Select your upper limits column in the BIN range field. For us, this would be \$C\$2:\$C\$7.
9. Use the Output options section to select where you want the output to appear. You may pick an output range in the same worksheet, create a new worksheet, or an entirely new workbook.
10. Make sure to select Chart Output. When done, click OK. Excel will put the histogram chart next to your frequency table.

11. Done!

Bonus tip: It’s up to you how many BINs you have in your column, however, most tables stick to around 5 to 10. Ensure that your BINs include all of your lower values, as well as all of your upper values.