PROB(x_range, prob_range, [lower_limit], [upper_limit])
PROB(A3:A6,B3:B6,2)
The PROB function can be used to calculate the probability of an event occurring. For example, if you have a range of cells containing input values (A3:A6) and a range of cells containing output values (B3:B6), you can use the formula above to determine the probability that x is 2.
PROB(A3:A6,B3:B6,1,3)
The PROB function can also be used to determine the probability that x is within a certain range. For example, this returns the probability that x is between 1 and 3.
The PROB function returns the probability of a range of values being between two limits. If the sum of the values is not equal to 1, it will return an error. If the upper_limit is omitted, it will also return an error. It will also return the probability of being less than or equal to the lower_limit.