NEGBINOMDIST function
From Apache OpenOffice Wiki
< Documentation | How Tos
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