FREQUENCY

Syntax:

FREQUENCY ( data-array , bins-array )

Description: Calculates how often values occur within a range of values. A call to FREQUENCY shall be entered as an array formula.

Arguments:

Name

Type

Description

data-array

array, reference to number

Set of values for which frequencies are to be computed. If data-array contains no values, FREQUENCY returns an array of zeros. Cells containing text or that are empty are ignored.

bins-array

array, reference

Set of intervals into which the values in data-array are to be grouped. If bins-array contains no values, FREQUENCY returns the number of elements in data-array.

Return Type and Value: vertical array of numbers – The frequency at which values occur within a range of values. The number of elements in the returned array is one more than the number of elements in bins-array. The extra element contains the count of any values above the highest interval.

example: