ReferenceFunctionsStatistics Functions
BINOM.DIST
BINOM.DIST: Returns the binomial probability for a count of successes across independent trials.
Summary
Use BINOM.DIST to evaluate either exact-success probability (PMF) or cumulative probability
up to a success count (CDF).
Remarks
number_sandtrialsare truncated to integers.- Requires
0 <= number_s <= trials,trials >= 0, and0 <= probability_s <= 1. - Set
cumulativeto non-zero for CDF mode, or0for PMF mode. - Returns
#NUM!for invalid count or probability ranges.
Examples
Binomial PMF for exactly 3 successes
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.1171875
Binomial CDF for at most 3 successes
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.171875
Related functions
Runtime metadata
Category
Statistics
Signature
BINOM.DIST(arg1: Number, arg2: Number, arg3: Number, arg4: Number)Arity
min 4, max 4
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
arg3Number · Scalar · coercion NumberLenientText
arg4Number · Scalar · coercion NumberLenientText
Caps
PURE
Source