The following article introduces you to the BINOM.INV function - one of the functions in the statistical function group is very popular in Excel.
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!