# BINOM.DIST.RANGE函数

## 描述

BINOM.DIST.RANGE函数使用二项式分布返回试验输出的概率。

## 语法

BINOM.DIST.RANGE (trials,probability_s,number_s,[number_s2])


## 争论

Argument描述Required/Optional
TrialsThe number of independent trials. Must be greater than or equal to 0.Required
Probability_sThe probability of success in each trial. Must be greater than or equal to 0 and less than or equal to 1.Required
Number_sThe number of successes in trials. Must be greater than or equal to 0 and less than or equal to Trials.Required
Number_s2

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

## 相关推荐

Linux内核技术实战课 -〔邵亚方 - 〕

React Hooks 核心原理与实战 -〔王沛 - 〕

## 视频推荐

JavaScript - 21-变量属性函数方法的区别