Returns the probability of a sample with binomial distribution.
B(Trials; SP; T1; T2)
Trials is the number of independent trials.
SP is the probability of success on each trial.
T1 defines the lower limit for the number of trials.
T2 (optional) defines the upper limit for the number of trials.
What is the probability with ten throws of the dice, that a six will come up exactly twice? The probability of a six (or any other number) is 1/6. The following formula combines these factors:
=B(10;1/6;2) returns a probability of 29%.