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