How to calculate frequency distribution in Excel?
A frequency distribution is a summary of counting how often values occur within a range of values, take the following screenshot for example, column B contains the score numbers, D2:E6 is the score bands you specified by yourself, and the Frequency column get the value occurs based on the bands. This article, I will talk about how to calculate the frequency distribution based on specific bands you defined.
Find and return the most common / frequent value in a list:
With Kutools for Excel’s Find most common value feature, you can find and extract the most frequent value which appeared from a column in Excel quickly without any formula.
Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!
In fact, there is a built-in Frequency function in Excel which can help you to calculate how often values occur within a range of values you specified please do as follows:
1. After specifying the score bands, then select the cells beside your bands where you want to put the result of frequency distribution, see screenshot:
2. And then enter this formula: =FREQUENCY($B$2:$B$16,$E$2:$E$6) (B2:B16 is the list values that you want to use, E2:E6 is the bands you specified ) into the formula bar, see screenshot:
3. Then press Ctrl + Shift + Enter keys together, and all the frequency distributions for each band are calculated at once, see screenshot: