In This Topic

FREQUENCY

In This Topic

This function calculates how often values occur within a range of values. This function returns a vertical array of numbers.

FREQUENCY(*dataarray*,*binarray*)

This function has these arguments:

Argument | Description |
---|---|

dataarray |
Array of values or a reference to a set of values for which to count frequencies |

binarray |
Array of intervals or a reference to intervals into which to group the values of dataarray |

The number of elements in the returned array is one greater than the number of elements in *binarray*. The extra element in the returned array is the count of values in *dataarray* that is above the highest value in *binarray*.

Use the INDEX function to get individual elements from the returned arrays.

Accepts an array. Returns an array.

FREQUENCY(A1:A7,C2:C5)

This function is available in product version 2.0 or later.

AVEDEV | AVERAGEA | CONFIDENCE | DEVSQ | MEDIAN | VAR | Statistical Functions