BINOM.DIST returns probability as a decimal number between 0 and 1.
Binary data shows up when an observation can be placed into only two categories.
For example, when tossing a coin, the result can only be heads or tails.
Or, when rolling a die, the result can either be 6 or not 6.
Since a die has six sides, the probability of rolling a 6 is 1/6, or 0.1667.
The probability of rolling one 6 in 10 trials is about 32%.
The formula in D5 is the same, except thecumulativeargument has been set to TRUE.