Menu
EXCEL NEGBINOMDIST FUNCTION
Excel NEGBINOMDIST Function Introduction
The Excel NEGBINOMDIST function computes the Negative Binomial Distribution for a given set of conditions based on the likelihood of success from a singular incident.
This indicates the likelihood that a certain number of failures will occur before a certain number of triumphs are reached.
For example, given a 50% chance that a coin flip will fall on heads, the Negbinomdist function may be used to compute the likelihood that you will toss 10 tails before tossing 12 heads.
Description of Excel NEGBINOMDIST Function
Syntax :
=NEGBINOMDIST( number_f, number_s, probability_s )
Parameters :
- The following parameter are:
number f –
- The number of failures experienced prior to number s successes.
number s –
- The number of successes necessary.
probability s –
- The chance of success in a single trial.
Step By Step Guide of NEGBINOMDIST Function
Example :
The graphic on the right depicts the Negative Binomial Distribution Function for the likelihood that a coin flip would result in precisely x tails before 12 heads.
The spreadsheets below demonstrate the Excel Negbinomdist function, which was used to assess this function for three distinct x values.
The likelihood of tossing a head on any given trial is obviously 0.5, hence this is used as the probability argument in the functions.
Key Points
- #NUM! – Occurs if either: the supplied number f is 0 or the supplied number s is 1; or the supplied probability s is 0 or greater than 1.
- #VALUE! – This error occurs if any of the number f, number s, or probability s inputs are not numeric.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
