NEGBINOMDIST Function in Excel: Syntax, Examples and Free Practice
NEGBINOMDIST is an Excel Compatibility function. Legacy negative binomial distribution — kept for compatibility with older files.
NEGBINOMDIST syntax
Arguments
number_f: The number of failuresnumber_s: The number of successesprobability_s: The probability of success on a single trial
When to use NEGBINOMDIST
NEGBINOMDIST is kept mainly for opening older files built in earlier versions of Excel.
Practice NEGBINOMDIST online, free
Open the live Excel-style spreadsheet and try NEGBINOMDIST yourself. No Excel install or sign-up needed to start.
Practice NEGBINOMDIST now →More Compatibility functions
- BETADIST
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- COVAR
- CRITBINOM
- EXPONDIST
- FDIST
- FINV
- FTEST
- GAMMADIST
- GAMMAINV
Frequently asked questions
What does the NEGBINOMDIST function do in Excel?
Legacy negative binomial distribution — kept for compatibility with older files.
What is the syntax of NEGBINOMDIST in Excel?
The syntax is =NEGBINOMDIST(number_f, number_s, probability_s). number_f: The number of failures; number_s: The number of successes; probability_s: The probability of success on a single trial.
Where can I practice NEGBINOMDIST online for free?
Open the free live spreadsheet on Cellgrids and try NEGBINOMDIST yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Compatibility functions · Excel case studies · Excel tutorials · Excel shortcuts