 Formula Engine Reference Guide |
|
Back to Class Index
FREQUENCY(R, B)
This function 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] <= [i] < y[2]
...
number of elements of x s.t. y[n-1] < lte> x[i] < y[n]
number of elements of x s.t. y[n] <= x[i]
Parameters
R
A range of values on which frequencies will be counted
B
A range of intervals used to group values in R
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