BINOM. INV Function in Excel

This guide provides a practical overview of BINOM. INV Function, including its main features, benefits, limitations, and important considerations.

Description: The function returns the smallest value with the cumulative binomial distribution greater than or equal to the standard value. Support function from Excel 2010 version.

Syntax: BINOM. INV (trials, probability_s, alpha)

Inside:

- trials: Number of independent trials, required.

- probability_s: The probability of success of each test, is a required parameter.

- alpha: Standard value, is a required parameter.

Attention:

- If any values of arguments are not whole numbers -> they are truncated to integers.

- If number_ s and trials are not numbers -> the function returns the #VALUE! Error value

- If trials <0 -> the function returns the #NUM! Error value

- If probability_s <0 or probability_s> 1 -> the function returns the #NUM! Error value

- If alpha <0 or alpha> 1 -> the function returns the #NUM! Error value

For example:

Calculate the minimum value so that the cumulative binomial distribution is greater than or equal to a criterion value with the figures in the table below:

- In the cell to calculate enter the formula : = BINOM. INV (C6, C7, C8)

- Press Enter -> minimum value is:

- Where probability_s> 1 or probability_s <0 -> the function returns the #NUM! Error value

- Where alpha> 1 or alpha <0 -> the function returns the #NUM! Error value

Above are instructions and specific examples when using the BINOM. INV function in Excel.

Good luck!