PROB function
Values
An array of possible values, where the corresponding probabilities are
given as the probabilities
parameter. This array must have
the same size as the probabilities
parameter.
Probabilities
The probabilities associated with the corresponding elements of the
values
array (ranging from 0, exclusive, to 1, inclusive).
This array must have the same size as the values
parameter. The sum of all elements of this array must be 1.
Start
The start value of the interval whose probabilities are summed. If omitted, it is assumed to be 0.
End
The end value of the interval whose probabilities are summed. If
omitted, it is assumed to be equal to the start
parameter.
Returns
The probability that a sample value is inside a given interval.
Returns the probability that a value is inside a given interval. It does this by finding all values which are inside the given interval and returning the sum of their probabilities.
Examples
Returns 0.8, the sum of the probabilities for 4, 5 and 6. Calculation: 0.2 * 0 + 0.4 * 1 + 0.3 * 1 + 0.1 * 1 = 0.80,2 * 0 + 0,4 * 1 + 0,3 * 1 + 0,1 * 1 = 0,8.