Navigation:  Formula Reference > Spreadsheet Formula Functions >

FREQUENCY

Previous pageReturn to chapter overviewNext page

 

This function calculates how often values occur within a range of values. This function returns a vertical array of numbers.

Syntax

FREQUENCY(dataarray,binarray)

Arguments

This function has these arguments:

Argument

Description

dataarray

Array of values or a reference to a set of values for which to count frequencies

binarray

Array of intervals or a reference to intervals into which to group the values of dataarray

Remarks

The number of elements in the returned array is one greater than the number of elements in binarray. The extra element in the returned array is the count of values in dataarray that is above the highest value in binarray.

Use the INDEX function to get individual elements from the returned arrays.

Data Types

Accepts an array. Returns an array.

Examples

FREQUENCY(A1:A7,C2:C5)

 

See Also

AVEDEV

AVERAGEA

CONFIDENCE

DEVSQ

MEDIAN

VAR