FREQUENCY
Definition
Calculates the frequency distribution of a one-column array into specified classes.
Sample Usage
Syntax
FREQUENCY(data, classes)
data- The array or range containing the values to be counted.classes- The array or range containing the set of classes.classesshould be sorted for clarity, butFREQUENCYwill sort the values specified internally if they are not and return correct results.
Notes
- The output of
FREQUENCYwill be a vertical range of size one greater thanclassesas the final value is the number of elements indatagreater than any of the class boundaries.
In order to use the FREQUENCY formula, start with your edited Excellentable:
A
|
B
|
|
|---|---|---|
1
|
||
2
|
||
3
|
||
4
|
||
5
|
||
6
|
||
7
|
||
8
|
||
9
|
||
10
|
||
11
|
||
12
|