PROB function
Summary
Returns the probability that values in a range are between two limits
Syntax
PROB(x_range, prob_range, [lower_limit], [upper_limit])
The PROB function syntax has the following arguments:
• 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 on the value for which you want a probability.
• 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 on the value for which you want a probability.
Example
=PROB(A3:A6,B3:B6,2)
=PROB(A3:A6,B3:B6,1,3)
=PROB(A3:A6,B3:B6,1,3)