Manuals/calci/FREQUENCY

FREQUENCY(DataArray, BinArray)

• Where $DataArray$ is an 'array of values' or 'reference to set of values' from which frequency of values is to be counted, and
• $BinArray$ is an array or a reference to intervals in which values can be grouped.

FREQUENCY() calculates the number of occurrences within a range of values, and then returns a horizontal array of the count.

Description

FREQUENCY(DataArray, BinArray)

• $DataArray$ is an input array from which frequency of values is to be calculated.
• If $DataArray$ does not contain values, it returns array of zeros.
• $BinArray$ is an array of intervals in which input values are to be grouped.
• If $BinArray$ has no values, Calci returns the number of values in DataArray.
• Blank cells are considered as zero value.
• Text values are ignored.

Examples

Below table shows the use of FREQUENCY function:

5	10
20	30
15.5	50
21
0.3
45
38
-2

=FREQUENCY(A1:A8,B1:B3) : Returns the frequencies as 3(for values < 10), 3(for values between 10 and 30), 
2(for values between 30 and 50), 0(for values > 50). Displays 3  3  2  0 as a result.
=FREQUENCY(A1:A9,B1:B3) : Returns the frequencies as 4(for values < 10, A9 is considered '0'),
 3(for values between 10 and 30), 2(for values between 30 and 50), 0(for values > 50). 
Displays 4  3  2  0 as a result.

Related Videos

FREQUENCY Function

See Also

• COUNT
• COUNTA

References

• Frequency