Quick Navigation
BINOM.DIST.RANGE Function
Summary
The BINOM.DIST.RANGE function calculates the probability of achieving a specific number of successes—or a range of successes—in a fixed number of independent trials, each with the same probability of success. This is essential for binomial distribution analysis in quality control, risk assessment, and statistical modeling.
Syntax
BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| trials | Number |
Yes | Total number of independent Bernoulli trials (≥ 0) |
| probability_s | Number |
Yes | Probability of success per trial (0 ≤ value ≤ 1) |
| number_s | Number |
Yes | Lower bound: number of successes in trials (0 ≤ value ≤ trials) |
| number_s2 | Number |
No | Optional upper bound for range of successes (number_s ≤ value ≤ trials) |
Using the BINOM.DIST.RANGE Function
BINOM.DIST.RANGE is perfect for calculating probabilities in binary outcome scenarios. Use it without number_s2 for the probability of exactly 'number_s' successes, or include number_s2 to get the probability of successes falling within a range—ideal for tolerance analysis and statistical process control.
Common BINOM.DIST.RANGE Examples
Exact Probability of Specific Successes
=BINOM.DIST.RANGE(60,0.75,48)Probability of exactly 48 successes in 60 trials with 75% success rate (returns 0.084 or 8.4%)
Probability Within Success Range
=BINOM.DIST.RANGE(60,0.75,45,50)Probability of 45-50 successes (inclusive) in 60 trials with 75% success rate (returns 0.524 or 52.4%)
Quality Control Example
=BINOM.DIST.RANGE(100,0.95,92)Probability of exactly 92+ defect-free items in a batch of 100 with 95% quality rate
Frequently Asked Questions
Common Errors and Solutions
#NUM! error
Cause: Arguments outside constraints (negative trials, probability >1 or <0, number_s > trials)
Solution: Verify all parameters meet requirements: trials≥0, 0≤probability_s≤1, 0≤number_s≤trials
#VALUE! error
Cause: Non-numeric arguments
Solution: Ensure all inputs are valid numbers
Notes
- Uses summation of binomial probabilities: Σ BINOM.DIST(k, trials, probability_s, FALSE) for k from number_s to number_s2
- Replaces older BINOMDIST function for range calculations
- Perfect for hypothesis testing, A/B testing results, and reliability engineering
Compatibility
Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365, Excel for Mac 2011+, Excel Online
Not available in: Excel 2007, Excel 2003, Earlier versions
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+