MicroStrategy ONE

BinomialDistribution

Returns either the binomial probability or the cumulative binomial probability of variables n and p. This function is used in cases in which:

  • There is a fixed number of tests
  • Each test can only result in either success or failure (binary)
  • Tests are independent of all other tests
  • The probability of success is constant, for example, to calculate the probability that two out of the next three babies will be male

Syntax

BinomialDistribution <Cumulative> (x, n, p)

Where:

x is the number of successes.

n is the number of tests.

p is the number indicating the probability of a success in each trial.

Cumulative is a logical value that determines the form of the function.

  • If Cumulative=0, it computes the Cumulative Binomial probability.
  • If Cumulative=1, it computes the Binomial probability.

Expression

For the binomial probability:

Where:

is Combine(n, x).

The cumulative binomial distribution is:

Usage Notes

If x or n is not an integer, it is truncated.

The following conditions are invalid:

  • One of the arguments is nonnumeric.
  • x > n
  • x< 0
  • p < 0 or p > 1