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] ![]() |
number of elements of x
s.t. y[1] ![]() ![]() |
||
... | ||
number of elements of x
s.t. y[n-1] ![]() ![]() |
||
number of elements of x
s.t. y[n] ![]() |
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