Syntax
=NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)Arguments
| Argument | Required | Description |
|---|---|---|
number_f | Required | The number of failures |
number_s | Required | The number of successes |
probability_s | Required | The probability of success |
cumulative | Required | TRUE for the cumulative distribution, FALSE for the density |
How to use NEGBINOM.DIST
NEGBINOM.DIST takes 4 required arguments. Type =NEGBINOM.DIST( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=NEGBINOM.DIST(10, 5, 0.25, TRUE)Result =NEGBINOM.DIST(10, 5, 0.25, FALSE)Result Related statistical functions
- MINAReturns the smallest value, counting text as 0 and TRUE as 1.
- MINIFSReturns the smallest number among the cells that meet all conditions.
- MODE.MULTReturns a vertical list of all values that occur most often.
- MODE.SNGLReturns the value that occurs most often.
- NORM.DISTReturns the normal distribution for a mean and standard deviation.
- NORM.INVReturns the value at which the normal distribution reaches a probability.
- NORM.S.DISTReturns the standard normal distribution (mean 0, standard deviation 1).
- NORM.S.INVReturns the value at which the standard normal distribution reaches a probability.
- PEARSONReturns the Pearson correlation coefficient of two sets of numbers.