BINOM.DIST.RANGE Function (LibreOffice Calc)

• Computes P(a ≤ X ≤ b) for a binomial distribution
• Supports single‑value probability (a = b)
• More efficient and readable than summing multiple BINOM.DIST calls
• Used in quality control, reliability, and discrete probability modeling

Two‑argument form (single value)

BINOM.DIST.RANGE(trials; probability_s; number_s)

Three‑argument form (range)

BINOM.DIST.RANGE(trials; probability_s; number_s; number_s2)

Arguments

• trials:
  Number of trials (integer ≥ 0).

• probability_s:
  Probability of success on each trial (0–1).

• number_s:
  Lower bound of successes (integer ≥ 0).

• number_s2 (optional):
  Upper bound of successes (integer ≥ number_s).

Probability of exactly 3 successes

=BINOM.DIST.RANGE(10; 0.5; 3)

Probability of 3 to 5 successes

=BINOM.DIST.RANGE(10; 0.5; 3; 5)

Using cell references

=BINOM.DIST.RANGE(A1; B1; C1; D1)

Quality control: probability of 0–2 defects

=BINOM.DIST.RANGE(100; 0.01; 0; 2)

Reliability: probability of at least k failures

=1 - BINOM.DIST.RANGE(n; p; 0; k-1)

Probability of a tail region (X ≥ k)

=BINOM.DIST.RANGE(n; p; k; n)

Probability of an interval around the mean

=BINOM.DIST.RANGE(n; p; n*p - 2; n*p + 2)

Manual equivalent using BINOM.DIST

=SUM(BINOM.DIST(ROW(INDIRECT(a&":"&b)); n; p; FALSE))

Probability of an exact range for A/B testing

=BINOM.DIST.RANGE(A1; A2; A3; A4)

BINOM.DIST.RANGE returns a numeric probability between 0 and 1

Accepts:

• Integer trials
• Integer number_s and number_s2
• 0 ≤ probability_s ≤ 1

Behavior details

• If number_s > trials → returns 0
• If number_s2 > trials → capped at trials
• If number_s2 omitted → computes P(X = number_s)
• Range is inclusive: a ≤ X ≤ b
• Equivalent to summing PMF values

Invalid input → Err:502

BINOM.DIST.RANGE of an error → error propagates

• Use BINOM.DIST.RANGE for multi‑value binomial probabilities
• Use BINOM.DIST for single PMF/CDF values
• Validate integer inputs
• Use BINOM.INV for quantile calculations
• Use tail formulas for reliability and risk modeling

• Use BINOM.DIST for PMF/CDF
• Use BINOM.INV for inverse binomial distribution
• Use POISSON.DIST for rare‑event approximations
• Use COMBIN for manual PMF calculations

By mastering BINOM.DIST.RANGE, you can build precise, efficient statistical and probability‑driven models in LibreOffice Calc.