FREQUENCY
Calculates how often values occur within a range of values, and then returns a vertical array of numbers. For example, use FREQUENCY to count the number of test scores that fall within ranges of scores. Because FREQUENCY returns an array, it must be entered as an array formula.
Syntax
FREQUENCY(data_array,bins_array)
Data_array—is an array of or reference to a set of values for which you want to count frequencies. If data_array contains no values, FREQUENCY returns an array of zeros.
Bins_array—is an array of or reference to intervals into which you want to group the values in data_array. If bins_array contains no values, FREQUENCY returns the number of elements in data_array.
Remarks
- FREQUENCY is entered as an array formula after you select a range of adjacent cells into which you want the returned distribution to appear.
- The number of elements in the returned array is one more than the number of elements in bins_array.
- FREQUENCY ignores blank cells and text.
- Formulas that return arrays must be entered as array formulas.
Example
Suppose a worksheet lists scores for a test. The scores are 79, 85, 78, 85, 83, 81, 95, 88, and 97 and are entered into A1:A9, respectively. The data_array would contain a column of these test scores. The bins_array would be another column of intervals by which the test scores are grouped. In this example, bins_array would be C4:C6 and would contain the values 70, 79, 89. When FREQUENCY is entered as an array, the number of scores corresponding to the letter grade ranges 0-70, 71-79, 80-89, and 90-100, are counted. This example assumes all test scores are integers. The following formula is entered as an array formula after you select four vertical cells adjacent to your data.
FREQUENCY(A1:A9,C4:C6)
equals {0;2;5;2}