FREQUENCY Function Explained
The FREQUENCY function in Microsoft Excel returns a frequency distribution, which is an array of numbers that correspond to the number of times a value occurs in a given data set. It takes two arguments: an array of data and an array of bins. The bins are the upper bounds of the intervals into which the data is grouped. The function returns an array of numbers, each of which corresponds to the number of values in the data set that fall within the corresponding bin.
FREQUENCY Function Syntax
FREQUENCY(data_array, bins_array)
- data_array: An array of numeric values for which you want to count frequencies.
- bins_array: An array of intervals into which you want to group the values in data_array.