BINOM.DIST.RANGE function
Returns the probability of a trial result using a binomial distribution
Syntax
BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| trials | Yes | The number of independent trials.60 |
| probability_s | Yes | The probability of success on each trial.0.75 |
| number_s | Yes | The number of successes in trials.45 |
| number_s2 | No | If provided, returns the probability that the number of successful trials will fall between number_s and number_s2.50 |
Try BINOM.DIST.RANGE
Combine one-success and two-success events
=BINOM.DIST.RANGE(A2,B2,C2,D2)The inclusive event is one or two successes. Their sequence counts are 4 and 6, so the combined probability is 10/16.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
BINOM.DIST.RANGE · top-level call
=BINOM.DIST.RANGE(A2,B2,C2,D2)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.