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
Search JabSto ::




Custom Search