Microsoft Office Tutorials and References

In Depth Information

**PROB**

be
between
zero and
x). If FALSE, the probability mass function is

returned (the probability that exactly
x
events will occur).

Figure 11.37

Cumulative can be

TRUE or FALSE with

regard to the
POISSON

function.

PRO
PROB
returns the probability that values in a range are between two specified limits (as shown

in Figure 11.38).

=PROB(x_range,prob_range,lower_limit,upper_limit)

Is the range of values with which there are associated probabilities.

X_RANGE

Is a set of probabilities associated with the
x_values
. The sum of the

probabilities in this range must equal one (1).

PROB_RANGE

Is the lower bound on the value for which you want a probability.

LOWER_LIMIT

Is the upper bound on the value for which you want a probability; an

optional argument.

UPPER_LIMIT

Figure 11.38

If
UPPER_LIMIT
is

omitted, the function

returns the probability

that the values in

X_RANGE
are equal to

LOWER_LIMIT
.