BINOM.DIST Function in Excel: Syntax, Examples and Free Practice
BINOM.DIST is an Excel Statistical function. Returns the individual term binomial distribution probability.
BINOM.DIST syntax
Arguments
number_s: The number of successestrials: The number of independent trialsprobability_s: The probability of success on a single trialcumulative: TRUE for the cumulative distribution, FALSE for the probability mass
When to use BINOM.DIST
BINOM.DIST is used in data analysis work to summarize or test patterns across a data set.
Practice BINOM.DIST online, free
Open the live Excel-style spreadsheet and try BINOM.DIST yourself. No Excel install or sign-up needed to start.
Practice BINOM.DIST now →More Statistical functions
Frequently asked questions
What does the BINOM.DIST function do in Excel?
Returns the individual term binomial distribution probability.
What is the syntax of BINOM.DIST in Excel?
The syntax is =BINOM.DIST(number_s, trials, probability_s, cumulative). number_s: The number of successes; trials: The number of independent trials; 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 BINOM.DIST online for free?
Open the free live spreadsheet on Cellgrids and try BINOM.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