NEGBINOM.DIST Function in Excel: Syntax, Examples and Free Practice
NEGBINOM.DIST is an Excel Statistical function. Returns the negative binomial distribution.
NEGBINOM.DIST syntax
Arguments
number_f: The number of failuresnumber_s: The number of successesprobability_s: The probability of success on a single trialcumulative: TRUE for the cumulative distribution, FALSE for the probability mass
When to use NEGBINOM.DIST
NEGBINOM.DIST is used in data analysis work to summarize or test patterns across a data set.
Practice NEGBINOM.DIST online, free
Open the live Excel-style spreadsheet and try NEGBINOM.DIST yourself. No Excel install or sign-up needed to start.
Practice NEGBINOM.DIST now →More Statistical functions
Frequently asked questions
What does the NEGBINOM.DIST function do in Excel?
Returns the negative binomial distribution.
What is the syntax of NEGBINOM.DIST in Excel?
The syntax is =NEGBINOM.DIST(number_f, number_s, probability_s, cumulative). number_f: The number of failures; number_s: The number of successes; probability_s: The probability of success on a single trial; cumulative: TRUE for the cumulative distribution, FALSE for the probability mass.
Where can I practice NEGBINOM.DIST online for free?
Open the free live spreadsheet on Cellgrids and try NEGBINOM.DIST yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts