BINOM.DIST function
the individual term binomial distribution probability.
Statistical · Excel 2010+
Where can you use it?
Analytics, quality and research teams. Use this group to examine distributions, variability or relationships in measurements, sales or service durations.
Scenario in the workbook
For a success count in ten trials, calculate the probability at or below the input. Distribution parameters stay fixed in the three cases; edit the observation to test another case.
A worked example from the workbook
| Row | A |
|---|---|
| 6 | Observation |
| 7 | 0 |
| 8 | 3 |
| 9 | 7 |
=BINOM.DIST(A7,10,0.3,TRUE)Expected result0.0282475249
See the inputs and instructions for all 3 examplesSyntax
BINOM.DIST(number_s,trials,probability_s,cumulative)
Copyable formulas
=BINOM.DIST(0,2,0.5,FALSE)=BİNOM.DAĞ(0;2;0,5;YANLIŞ)Expected result
0.25
Worked examples
For a success count in ten trials, calculate the probability at or below the input. Distribution parameters stay fixed in the three cases; edit the observation to test another case.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A |
|---|---|
| 6 | Observation |
| 7 | 0 |
| 8 | 3 |
| 9 | 7 |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =BINOM.DIST(A7,10,0.3,TRUE) |
0.0282475249 |
| Record 2 | =BINOM.DIST(A8,10,0.3,TRUE) |
0.6496107184 |
| Record 3 | =BINOM.DIST(A9,10,0.3,TRUE) |
0.9984096136 |