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.
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 is 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
=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.