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

Grey Trout Software

02 March 2003