PROB (PQL - xl)
This function returns the probability that values in a range are between two limits
- Library: PQL \ Spreadsheet \ Statistical
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
PROB(x range, prob range, lower limit, upper limit)
Function Arguments
Name | Description | Type | Optional |
x range | Array of numeric values, which has corresponding probs | StringOrNumber |
|
prob range | Probabilities associated with the numeric values in array | StringOrNumber |
|
lower limit | Lower limit on the numeric value for which you want a probability | Number |
|
upper limit | Upper limit on the numeric value for which you want a probability; if omitted, returns the probability of result equal to lower limit | Number |
|
Comments
This function is the same as the Microsoft Excel 'PROB' function - using the same inputs, logic and outputs.