Syntax:
PROB( x range:Range or Array, associated probabilities:Range or Array, lower limit:Number {, upper limit:Number} )
Returns the probability that the values in x range with associated probabilities are between the lower limit and upper limit. If upper limit is omitted, this function returns the probability of being equal to the lower limit.
Formula:
PROB = i ∑1n ( I( xi, lower limit, upper limit) × pi )
where n is the number of values, xi is the i‑th value, pi is the associated probability for that value, and I(x,a,b) is the indicator function that yields 1 if x∈[a,b] and 0 otherwise.
Revisions:
This function was added in Fireworkz 2.00.