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.