Skip to main content

FREQUENCY

Calculates how often values occur within a range of values and returns a vertical array of numbers.

CategoryStatistical
SyntaxFREQUENCY(data_array, bins_array)

Parameters

ParameterRequiredDescription
data_arrayRequiredThe array or range of values for which to count frequencies.
bins_arrayRequiredThe array or range of intervals into which to group data_array values.

Example

FREQUENCY(A1:A10)

Auto-generated from the EngCanvas function registry.