Skip to main content

BINOM.INV

Definition

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Sample Usage

Syntax

BINOM.INV(trials,probability_s,alpha)

The BINOM.INV function syntax has the following arguments:

  • Trials     Required. The number of Bernoulli trials.

  • Probability_s     Required. The probability of a success on each trial.

  • Alpha     Required. The criterion value.

Remarks

  • If any argument is nonnumeric, BINOM.INV returns the #VALUE! error value.

  • If trials is not an integer, it is truncated.

  • If trials < 0, BINOM.INV returns the #NUM! error value.

  • If probability_s is < 0 or probability_s > 1, BINOM.INV returns the #NUM! error value.

  • If alpha < 0 or alpha > 1, BINOM.INV returns the #NUM! error value.

In order to use the BINOM.INV formula, start with your edited Excellentable:


Then type in the BINOM.INV formula in the area you would like to display the outcome:


By adding the values you would like to calculate the BINOM.INV formula for, Excellentable will generate the outcome:



A
B
1
Description
Data
2
Number of Bernoulli trials
6
3
Probability of a success on each trial
0.5
4
Criterion value
0.5
5
6
BINOM.INV
3

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.