PROB

Syntax:

PROB ( x-range , probability-range , lower-limit [ , upper-limit ] )

Description: Computes the probability that values in a range are between two limits.

Arguments:

Name

Type

Description

x-range

array, reference

The set of numeric values of x with which there are associated probabilities.

probability-range

array, reference

A set of numeric probabilities associated with the values in x-range.

lower-limit

number

The lower bound on the value for which the probability is to be computed.

upper-limit

number

The upper bound on the value for which the probability is to be computed. If omitted, the probability that values in x-range are equal to lower-limit is returned.

Return Type and Value: number – The probability that values in a range are between two limits.

However, if

  • Any value in probability-range ≤ 0 or any value in probability-range > 1, #NUM! is returned.

  • The sum of the values in probability-range < 1, #NUM! is returned.

  • x-range and probability-range contain a different number of data points, the return value is unspecified.

example: