ID EN
…
#Statistical

FREQUENCY

Excel Functions

Get the frequency of values in a data set

Syntax

EXCEL 
=FREQUENCY(data_array, bins_array)

Arguments

Parameter Description
data_array An array of values for which you want to get frequencies.
bins_array An array of intervals ("bins") for grouping values.

Return Value

A vertical array of frequencies

Details

The FREQUENCY function counts how often numeric values occur in a set of data and returns a frequency distribution – a list that shows the frequency (count) of each value in a range at given intervals (bins). FREQUENCY returns the distribution as a vertical array of numbers that represent a "count per bin". The FREQUENCY function always returns an array with one more item than bins in the bins_array. This is by design, to catch any values greater than the largest value in the bins_array. The general pattern for FREQUENCY is: where data_array and bins_array are typically ranges on the worksheet. To create a frequency distribution using FREQUENCY: In Excel 365, it is not necessary to enter FREQUENCY as an array formula. See notes below.

Examples

Example 1

The FREQUENCY function always returns an array with one more item than bins in the bins_array. This is by design, to catch any values greater than the

EXCEL 
=FREQUENCY(data,bins)
Examples

In the example shown, the formula in G5:G8 is:

EXCEL 
{=FREQUENCY(C5:C14,F5:F8)}
Horizontal results

The FREQUENCY function always returns a vertical array of results. To return horizontal results, wrap the FREQUENCY function in the TRANSPOSE function

EXCEL 
=TRANSPOSE(FREQUENCY(data,bins))
Excel 365

In Excel 365, which supports dynamic arrays natively, it is not necessary to select multiple cells before entering the FREQUENCY function. In cell G5,

EXCEL 
=FREQUENCY(C5:C14,L5:L8)

See Also

MODE