NEGBINOMDIST function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
NEGBINOMDIST
Calculates probabilities for a negative binomial distribution.
Syntax:
NEGBINOMDIST(x; r; p)
- For independent trials each with a probability p of success, NEGBINOMDIST returns the probability that there will be exactly x failures before there have been r successes. The formula used is:
Example:
NEGBINOMDIST(1; 1; 0.5)
- returns 0.25 (25%), the probability that heads will come up exactly once, before tails has come up, when tossing a coin.
See Also
