PROB
Returns the probability that values in a range are between two limits
Syntax
PROB(x_range, prob_range, [lower_limit], [upper_limit])
Parameters
- x_range: Required. The range of numeric values of x with which there are associated probabilities
- prob_range: Required. A set of probabilities associated with values in x_range
- lower_limit: Optional. The lower bound on the value for which you want a probability
- upper_limit: Optional. The optional upper bound
Example
=PROB(A1:A5, B1:B5, 1, 3)