BINOM.INV Function in Excel: Syntax, Examples and Free Practice
BINOM.INV is an Excel Statistical function. Returns the smallest value where the binomial distribution is >= a criterion.
BINOM.INV syntax
Arguments
trials: The number of independent trialsprobability_s: The probability of success on a single trialalpha: A shape parameter of the distribution
When to use BINOM.INV
BINOM.INV is used in data analysis work to summarize or test patterns across a data set.
Practice BINOM.INV online, free
Open the live Excel-style spreadsheet and try BINOM.INV yourself. No Excel install or sign-up needed to start.
Practice BINOM.INV now →More Statistical functions
Frequently asked questions
What does the BINOM.INV function do in Excel?
Returns the smallest value where the binomial distribution is >= a criterion.
What is the syntax of BINOM.INV in Excel?
The syntax is =BINOM.INV(trials, probability_s, alpha). trials: The number of independent trials; probability_s: The probability of success on a single trial; alpha: A shape parameter of the distribution.
Where can I practice BINOM.INV online for free?
Open the free live spreadsheet on Cellgrids and try BINOM.INV 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