PROB()

Syntax. PROB(x_range,prob_range,lower_limit,upper_limit)

Definition. This function returns the probability for an interval between two values. If upper_limit is not specified, the function calculates the probability that the values in x_range are equal to lower_limit.

Arguments

  • x_range (required). The range of random variable realizations that have associated probabilities

  • prob_range (required). A set of probabilities associated with values in x_range

  • lower_limit (required). The lower limit of the values for which the probability is calculated

  • upper_limit (optional). The upper limit of the values for which the probability is calculated

Note

If any value in prob_range is less than or equal to 0 or greater than 1, the function returns the #NUM!

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial