Excel Function : FREQUENCY

Download now!

Excel Function : FREQUENCY




Returns a frequency distribution as a vertical array

Microsoft Excel Reference Page


Syntax and Description of the FREQUENCY Excel Function

FREQUENCY returns the number of data points in a data set that fall within a group of bins.

About FREQUENCY Excel Function

The FREQUENCY function returns a frequency distribution, which is a summary of values in a data set. The function uses the following syntax: FREQUENCY(data, bins). The data argument is the data set and the bins argument is the number of bins. The function returns an array of values that represent the frequency distribution.