FREQUENCY (frequency) |
  
|
FREQUENCY (frequency) |
|
Syntax:
FREQUENCY(Values, Limits)
Description:
This returns a frequency distribution for the given set of values. You can use this function to determine how many values from a data set are within certain intervals.
The result of this function is a vertical array (see notes below).
Values is a cell range or an array containing the values to be evaluated. Blank cells and text strings are ignored.
Bounds is a cell range or an array containing the bounds for the intervals. If, for example, Bounds is the array {10; 15; 42}, the function returns an array with the following values:
1. The number of values that are ≤ 10.
2. The number of values that are > 10 and ≤ 15.
3. The number of values that are > 15 and ≤ 42.
4. The number of values that are > 42.
Both Values and Bounds have to be vertical arrays, as they must not consist of more than one column.
Note:
Formulas using this function have to be entered as an array formula. For more information, see Working with arrays.
Please note that the array returned by this function contains one element more than the number of values in Bounds.
See also: