|
<< Click to Display Table of Contents >> FREQUENCY (frequency) |
Syntax:
FREQUENCY(Values, Bins)
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.
Bins constitute a cell range or an array containing the intervals to be evaluated. If, for example, Bins 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 Bins have to be vertical arrays, as they must not have 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 Bins.
See also: