关注我们

JavaScript 中的 BINOM.DIST.RANGE函数

描述

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。链接：https://www.learnfk.comhttps://www.learnfk.com/javascript/advanced-excel-statistical-binomdistrange-function.html 来源：LearnFk无涯教程网	Optional

使用以下公式

$$\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!。错误值。