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

Example

advanced_excel_statistical_functions.htm