MicroStrategy ONE
Criterion binomial
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. Use this function for quality control, for example, to determine the maximum number of defective items that can come off an assembly line run before rejecting an entire lot.
Syntax
CritBinomial(
Trials
,
Probability_s
,
Alpha
)
Where:
Trials
is the number of Bernoulli trials.
Probability_s
is the probability of a success on each trial.
Alpha
is the criterion value.
Usage Notes
The following conditions are invalid:
- Any argument is nonnumeric.
- Trials is not an integer.
- Trials < 0
- Probability_s is < 0 or probability_s > 1
- alpha < 0 or alpha > 1