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