<< Click to Display Table of Contents >> PROB (probability)

Syntax:

PROB(Values, Probabilities, k1 [, k2])

Description:

Returns the probability that a value is inside the specified interval of values, when the individual probabilities for each value are given.

More simply: This function sums up the respective Probabilities of the Values in this interval.

Values are the given values.

Probabilities are the probabilities associated with these values.

All Probabilities have to be in the range 0 (0%) to 1 (100%). Their sum has to be 1.

Values and Probabilities must have the same number of values, otherwise the function returns a #N/A error value.

k1 and k2 are the bounds of the interval whose cumulative probabilities you want to calculate. If k2 is omitted, just the probability of k1 will be returned.

Example:

Cells A1:A3 contain the values 1, 2, 3. Cells B1:B3 contain the probabilities associated with these values: 17%, 33%, 50%.

To calculate the probability that a value is between 2 and 3:

PROB(A1:A3, B1:B3, 2, 3) returns 33% + 50%, which equals 83%