The PROB function returns the probability of a collection of values, if you know the probabilities of the individual values.
PROB(num-set, probability-values, lower, upper)
num-set: A collection containing the number values.
probability-values: The collection containing the probability values. probability-values must contain number values and the sum of the number values must add up to 1. Any string values are ignored.
lower: A number value representing the lower limit or bound of the value(s) whose probability you want to know.
upper: An optional number value representing the upper limit or bound of the value(s) whose probability you want to know.
Notes
The PROB function sums the probabilities associated with all values in the collection greater than or equal to the specified lower limit value and less than or equal to the specified upper limit value. If upper is omitted, PROB returns the probability of the single number equal to the specified lower limit.
The two collections must be of the same size. If a string value is contained in a collection, it will be ignored.
Examples |
|---|
Suppose that a particular research study asked people to select a number between 12 and 16. In the following table, cells A1:A5 contain the possible choices (the numbers 12 through 16). The percentage that each number was chosen by those participating in the research, expressed as a decimal, is contained in B1:B5. |
A | B | |
|---|---|---|
1 | 12 | 0.17 |
2 | 13 | 0.32 |
3 | 14 | 0.15 |
4 | 15 | 0.19 |
5 | 16 | 0.17 |
=PROB(A1:A5, B1:B5, 15,16) returns 0.36, the probability that the number selected was 15 or 16. =PROB(A1:A5, B1:B5, 14) returns 0.15, the probability that the number selected was 14. |