|
<< Click to Display Table of Contents >> FREQUENCY (frequency) |
Syntax:
FREQUENCY(Values, Bounds)
Description:
Returns a frequency distribution for the given set of values. Use this function to count how many values are part of the specified 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. For example, if 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 (i.e., must not consist of more than one column).
Note:
Formulas using this function have to be entered as an array formula (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: