Documentation/How Tos/Calc: PROB function

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

PROB

Returns a result from a list of probabilities.

Syntax:

PROB(values; probabilities; start; end)

values is a range or array of numbers (possibly unordered).
probabilities is a range or array of numbers of the same size as values, indicating the corresponding probability (>0 and <=1) of each value in values occurring. The numbers in probabilities must sum to 1 exactly.
PROB finds all values which are between start and end inclusive and returns the sum of their corresponding probabilities.
end may be omitted, in which case PROB returns the probability corresponding to start (or 0 if start is not present in values).

Example:

PROB({3; 4; 5; 6}; {0.2; 0.4; 0.3; 0.1}; 4; 6)

returns 0.8, the sum of the probabilities for 4, 5 and 6.

PROB({2.2; 5; 1}; {0.5; 0.3; 0.2}; 0; 3)

returns 0.7, the sum of the probabilities for 1 and 2.2.

PROB({3; 4; 5; 6}; {0.2; 0.4; 0.3; 0.1}; 4)

returns 0.4, the probability for 4,