FREQUENCY

Syntax: FREQUENCY(R, B)

R = a range of values on which frequencies will be counted
B = a range of intervals used to group values in R

FREQUENCY returns a frequency distribution for a set of values R with a set of intervals B. The array returned is defined as follows:

Let x := x[1] ... x[m]
Let y := y[1] ... y[n]

FREQUENCY(x, y)	:=	number of elements of x s.t. x[i] $<$ y[1]
		number of elements of x s.t. y[1] $<=$ x[i] $<$ y[2]
		...
		number of elements of x s.t. y[n-1] $<=$ x[i] $<$ y[n]
		number of elements of x s.t. y[n] $<=$ x[i]

Example:

FREQUENCY(A1..A8, B1..B2) = 3, 3, 2 where A1..A8 = 70, 79, 80, 61, 83, 93, 88, 97 and B1..B2 = 80, 90

Excel function: FREQUENCY