Advanced Excel Statistical - PROB Function
Description
The PROB function returns the probability that values in a range are between two limits. If upper_limit is not supplied, returns the probability that values in x_range are equal to lower_limit.
Syntax
PROB (x_range, prob_range, [lower_limit], [upper_limit])
Arguments
Argument | Description | Required/ Optional |
---|---|---|
X_range | The range of numeric values of x with which there are associated probabilities. | Required |
Prob_range | A set of probabilities associated with values in x_range. | Required |
Lower_limit | The lower bound on the value for which you want a probability. | Optional |
Upper_limit | The optional upper bound on the value for which you want a probability. | Optional |
Notes
If upper_limit is omitted, PROB returns the probability of being equal to lower_limit.
If any value in prob_range ≤ 0 or if any value in prob_range > 1, PROB returns the #NUM! error value.
If the sum of the values in prob_range is not equal to 1, PROB returns the #NUM! error value.
If x_range and prob_range contain different number of data points, PROB returns the #N/A error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016