next up previous contents index
Next: FTEST Up: A. Function Reference Previous: FRAC   Contents   Index


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


next up previous contents index
Next: FTEST Up: A. Function Reference Previous: FRAC   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003