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