Related Functions:

The BINOM.INV function returns the inverse of the cumulative binomial distribution, i.e. for a given number of independent trials, the function returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.
  • BINOM.INV replaces the CRITBINOM function included in earlier versions of Excel.

Syntax

=BINOM.INV(trials,probability_s,alpha)

Arguments

Argument Description
trials The number of independent trials to be done
probability_s The probability of a success on each trial
alpha The criterion value – must be between 0 and 1

Examples

  A B C C
1 Data      
2 100 Number of Bernoulli trials    
3 0.5 Probability of a success on each trial    
4 0.75 Criterion value    
5        
6 Formula Result Notes
7 =BINOM.INV(A2,A3,A4) 53 Smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value
8 =BINOM.INV(100,50%,20%) 46
9 =BINOM.INV(100,50%,50%) 50

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are nonnumeric
#NUM! Occurs if either:

  the supplied trials argument is < 0
  the supplied probability_s argument is < 0 or > 1
  the supplied alpha argument is < 0 or > 1

The Cumulative Binomial Distribution, calculated by the BINOM.DIST function, is a statistical measure that is frequently used to indicate the probability of obtaining a specific number of successes from a specific number of independent trials.

The BINOM.INV function calculates the inverse of the cumulative binomial distribution, i.e. for a given number of independent trials, the BINOM.INV function returns the smallest value of x, the number of successes, for a specified cumulative binomial distribution probability.

See Wikipedia for more information on binomial distribution.