Microsoft Office Tutorials and References

In Depth Information

**NEGBINOMDIST**

Use
MODE
function when you need to know which value occurs most frequently in a data set.

If each value is unique, there is no mode and the error
#NA
is returned. If two or more values

occur with the same frequency, Excel returns the item with the smallest value regardless of the

order in which it encounters the values in the data set. Figure 11.29 shows an example of
MODE
.

Is the cell reference(s), range name, or array that makes up the data set.

Up to 30 arguments (unique data sets) can be specified.

NUMBER N

Figure 11.29

MODE
does not return

all values when more

than one value occurs

the same number of

times.

NEGBINOMDIST

NEGBINOMDIST
returns the negative binomial distribution.

=NEGBINOMDIST(number_f,number_s,probability_s)

The
NEGBINOMDIST
returns the probability that there will be
number_f
failures before
the

number_s-th
success, when the constant probability of a success is
probability_s
. With this

function, the number of successes is fixed and the number of trials is variable (see Figure 11.30).

Is the number of failures.

NUMBER_F

Is the threshold number of successes.

NUMBER_S

Is the probability of success.

PROBABILITY_S

The equation for
NEGBINOMDIST
is