FREQUENCY
Category: Statistical Function.
Description: Calculates how often values occur within a range of values, and then returns a vertical array of numbers.
Syntax: FREQUENCY(data_array, bins_array)
'Data_array' is an array of or reference to a set of values for which you wish 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 wish to group the values in 'data_array'.
If 'bins_array' contains no values, FREQUENCY returns the number of elements in 'data_array'.