CRITBINOM Function Explained
The CRITBINOM function in Microsoft Excel calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. It takes three arguments: trials, probability_s, and alpha. Trials is the number of independent trials, probability_s is the probability of success on each trial, and alpha is the criterion value.
CRITBINOM Function Syntax
CRITBINOM(trials, probability_s, alpha)
- trials: The number of independent trials.
- probability_s: The probability of success on each trial.
- alpha: The criterion value.