BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excel

The following article introduces you to the BINOM.INV function - one of the functions in the statistical function group is very popular in Excel.

BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excel Picture 1

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:

BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excel Picture 2

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

BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excel Picture 3

- Press Enter -> minimum value is:

BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excel Picture 4

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

BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excel Picture 5

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

BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excel Picture 6

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

Good luck!