FREQUENCY
Syntax:
FREQUENCY ( data-array , bins-array )
Description: Calculates how often values occur within a range of values. A call to FREQUENCY
shall be entered as an array formula.
Arguments:
Name |
Type |
Description |
---|---|---|
data-array |
array, reference to number |
Set of values for which frequencies are to be computed. If data-array contains no values, |
bins-array |
array, reference |
Set of intervals into which the values in data-array are to be grouped. If bins-array contains no values, |
Return Type and Value: vertical array of numbers – The frequency at which values occur within a range of values. The number of elements in the returned array is one more than the number of elements in bins-array. The extra element contains the count of any values above the highest interval.