Description Computes the smallest number of successes that will result in the cumulative BINOMDIST function giving an answer larger than a specified criteria value.
Syntax CRITBINOM (trials, probability, alpha)
Argument | Description |
---|---|
trials | An integer larger than 0 describing the total number of attempts in the test. |
probability | A value between 0 and 1 that represents the chance of success on an individual attempt. For example, the probability of heads in a coin toss is considered to be 0.6; the probability of getting "snake eyes" (two ones) when throwing a pair of dice is 1/36. |
alpha | A value between 0 and 1 that represents the overall criteria value. When the result of CRITBINOM is put into BINOMDIST, the value obtained from BINOMDIST will be equal to or larger than alpha. |
Examples This function returns 492:
This function returns 500: