Statistical - BINOM.INV Function

Description

The BINOM.INV function returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Syntax

BINOM.INV (trials,probability_s,alpha)

Arguments

Argument Description Required/ Optional
Trials The number of Bernoulli trials. Required
Probability_s The probability of a success on each trial. Required
Alpha The criterion value Required

Notes

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

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

  • 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

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

BinomInv Function
advanced_excel_statistical_functions.htm
Advertisements