FREQUENCY (PQL - xl)
This function calculates how often values occur within a range of values. This function returns a vertical array of numbers
- Library: PQL \ Spreadsheet \ Statistical
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
FREQUENCY(data array, bins array)
Function Arguments
Name | Description | Type | Optional |
data array | Array of values or a reference to a set of values for which to count frequencies | StringOrNumber |
|
bins array | Array of intervals or a reference to intervals into which to group the values of data array | StringOrNumber |
|
Comments
This function is the same as the Microsoft Excel 'FREQUENCY' function - using the same inputs, logic and outputs.