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.