The CRITBINOM function returns the smallest value such that the cumulative binomial distribution is greater than or equal to a predefined criterion value.
Instructions on how to use the CRITBINOM function in Excel
Syntax : CRITBINOM(trials,probability_s,alpha)
In there:
- trials : Required – This is the number of Bernoulli trials.
- probability_s : Required – This is the probability of success for each trial.
- alpha : Required – This is the criterion value.
Note:
- If any parameter is not a number, the function will return a #VALUE! error. - If the trials
value is not an integer, it will be rounded down to an integer. - If trials is less than 0, the function will return a #NUM! error . - If the probability_s value is less than 0 or greater than 1, the function will return a #NUM! error . - If alpha is less than 0 or greater than 1, the function will return a #NUM! error.
Consider the example
You enter your actual values corresponding to the function parameters into the Excel cells. In this example, the number of Bernoulli trials is 10, the probability of success for each trial is 0.6, and the criterion value is 0.8.
Enter the formula in cell C9. And the result of the function is 7.
So now you know how to use the CRITBINOM function in Excel. When entering parameters, make sure the arguments are numeric. If the number of Bernoulli trials is not an integer, Excel will automatically truncate the number for calculation.
The CRITBINOM function is combined with the COUNTIF and HLOOKUP functions.
When you have a list of names and need to count the number of occurrences in the table according to a specific requirement, the COUNTIF function will help you do that. The COUNTIF function allows you to count the number of occurrences based on a given condition.
If you have a transcript and academic ranking criteria for students, you will need to use the HLOOKUP function. The HLOOKUP function will retrieve the results that meet the criteria and then assign the corresponding academic ranking to the eligible students.