:BINOM.DIST.RANGE function-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. BINOM.DIST.RANGE function

BINOM.DIST.RANGE function

Author: daogeziyuan • • Table skills • Views 680
  • Picture and text skills
  • Case

Returns the probability of a trial outcome using the binomial distribution.


Grammar

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

The BINOM.DIST.RANGE function syntax has the following parameters.

Trials Required. Number of independent trials. Must be greater than or equal to 0.

Probability_s Required. The probability of success on each trial. Must be greater than or equal to 0 and less than or equal to 1.

Number_s Required. The number of successful trials. Must be greater than or equal to 0 and less than or equal to Trials.

Number_s2 Optional. If provided, returns the probability that the number of successful trials will be between Number_s and number_s2.

Must be greater than or equal to Number_s and less than or equal to Trials.


Description

￭If any argument is outside its restricted range, BINOM.DIST.RANGE returns the #NUM! error value.

￭If any argument is non-numeric, BINOM.DIST.RANGE returns the #VALUE! error value.

BINOM.DIST.RANGE.png

￭In the above formula, N is Trials, p is Probability_s, s is Number_s, s2 is Number_s2, and k is the iteration variable.

Numeric parameters are truncated.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/BINOM-DIST-RANGE-han-shu.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 粉尘 Columnist
48 196
single-end

Related Suggestion