ExcelFlux

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

RowA
6Observation
70
83
97
Record 1
=BINOM.DIST(A7,10,0.3,TRUE)

Expected result0.0282475249

See the inputs and instructions for all 3 examples

Syntax

BINOM.DIST(number_s,trials,probability_s,cumulative)

Copyable formulas

English Excel · en-US
=BINOM.DIST(0,2,0.5,FALSE)
Turkish Excel · tr-TR
=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
Microsoft Excel reference