描述
BINOM.DIST.RANGE函数使用二项式分布返回试验输出的概率。
语法
BINOM.DIST.RANGE (trials,probability_s,number_s,[number_s2])
争论
| Argument | 描述 | Required/Optional |
|---|---|---|
| Trials | The number of independent trials. Must be greater than or equal to 0. | Required |
| Probability_s | The probability of success in each trial. Must be greater than or equal to 0 and less than or equal to 1. | Required |
| Number_s | The number of successes in trials. Must be greater than or equal to 0 and less than or equal to Trials. | Required |
| Number_s2 |
如果提供,则返回成功试验次数将落在Number_s和number_s2之间的概率 必须大于或等于Number_s并且小于或等于Trials。 |
Optional |
Notes
-
使用以下公式
$$\sum_ {k = s} ^ {s2} \left(\frac {N} {k} \right)p ^ k \left(1-p \right)N-k $$
在上面的等式中,N是Trials,p是Probability_s,s是Number_s,s2是Number_s2,k是迭代变量。
数字参数被截断为整数。
If probability_s is < 0 or > 1, BINOM.DIST.RANGE returns the #NUM! error value. .
If number_s is < 0 or > trials, BINOM.DIST.RANGE returns the #NUM! error value.
If number_s2 is < 0 or > trials or < number_s, BINOM.DIST.RANGE returns the #NUM! error value.
如果任何参数是非数字值,则BINOM.DIST.RANGE返回#VALUE!。错误值。
适用性
Excel 2013,Excel 2016
Example
