Welcome back to our regular blog of Excel functions from A to Z. Today we look at the CRITBINOM function.
The CRITBINOM function
In probability theory and statistics, the binomial distribution with parameters North Y pag is the discrete probability distribution of the number of successes in a sequence of North successful independent experiments / failure, each of which produces success with probability pag. For the record, a successful experiment / failure is also called Bernoulli experiment or Bernoulli trial. The binomial distribution is often used to model the number of successes in a sample of size. North extracted with replacement of a population of size North.
This function returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. This may seem silly, but it is useful for creating standalone simulation analysis in Excel (see Simulation stimulation for more information).
For instance, the graphic (below) displays the cumulative binomial distribution function for 100 tosses of a coin. This curve represents the probability that at most X heads will be thrown 100 releases:
the Excel CRITBINOM The function calculates the inverse of the curve on the right, namely the CRITBINOM The function calculates the minimum value of X for which the binomial cumulative distribution function is a specified value.
The CRITBINOM The function uses the following syntax to operate:
CRITBINOM (essays, probability_s, alfa)
The CRITBINOM The function has the following arguments:
- essays: this is necessary and represents the number of Bernoulli trials
- probability_s: this is also necessary. This is the probability of success in each test.
- alfa: again, required. This represents the criterion value mentioned above.
It should also be noted that:
- this feature has been superseded by a newer feature (BINOM.INV) which can provide greater precision and whose name better reflects its use. Although this feature is still available for backwards compatibility, you should consider using the new features in the future, as this feature may not be available in future versions of Excel.
- if any argument is not numeric, CRITBINOM return the #VALUE! error value
- And trials it is not a whole number, is truncated
- And trials <0, CRITBINOM return the #ON ONE! error value
- And probability_s it is <0 O probability_s > 1, CRITBINOM return the #ON ONE! error value
- And alfa <0 O alfa > 1, CRITBINOM return the #ON ONE! error value.
Please, see my example below:
Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every business day.