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

Syntax:

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

Description:

This returns the probability that a value is within the specified interval of values when the individual probabilities for each value are given.

In simple terms: 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 within 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 determine the interval of values whose cumulative probabilities you want to calculate. If k2 is omitted, only 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% = 83%