BinomDist() returns the accumulated probability of the Binomial distribution.
Syntax:
BinomDist(value, trials, trial_probability)
Return data type: number
| Argument | Description |
|---|---|
| value | The value at which you want to evaluate the distribution. The value must be an integer not smaller than zero and not greater than the number of trials. |
| trials | A positive integer that states the number of trials. |
| trial_probability | The success probability for each trial. It is always a number between 0 and 1. |
This function is related
to the BinomInv function in the following way:
If prob = BinomDIST(value, trials, trial_probability), then BinomInv(prob, trials, trial_probability) = value