BIN

Syntax:

FREQUENCY( data:Range or Array, bins:Range or Array )

The bins range of cells (or array) defines a set of bins into which the numeric values (blanks and text strings being ignored) from the data range of cells (or array) is counted.

For example, if bins is {20,40,60,80}, the returned array gives the number of elements of data that have:

The returned array will therefore always have one more element than the bins range of cells (or array). Neither data nor bins need be sorted.

One common use of this function is to organise data for making a histogram.

Revisions:

This function was added in Fireworkz 2.00.