:BINOM.DIST function-Table skills免费ppt模版下载-道格办公

BINOM.DIST function

  • Picture and text skills
  • Case

Returns the probability of the binomial distribution.

BINOM.DIST is used to handle a fixed number of trials or experimental problems.

The premise is that the result of any experiment can only be success or failure. The experiment is an independent experiment, and the probability of success is fixed during the entire experiment.


For example, BINOM.DIST can calculate the probability that two of three upcoming babies will be boys.


Grammar

BINOM.DIST(number_s,trials,probability_s,cumulative)

BINOM.DIST1.png

BINOM.DIST function syntax has the following parameters:

Number_s: required. The number of successful trials.

Trials: required. Number of independent trials.

Probability_s: Required. The probability of success on each trial.

cumulative: required. A logical value that determines the form of a function.

If cumulative is TRUE, BINOM.DIST returns the cumulative distribution function, which is the probability that there are at most number_s successes;

If FALSE, returns the probability density function, which is the probability that there are number_s successes.


Description

■Number_s and trials will be truncated.

■ If number_s, trials, or probability_s are non-numeric, BINOM.DIST returns a #VALUE! error value.

■ If number_s < 0 or number_s > trials, BINOM.DIST returns the #NUM! error value.

■ If probability_s < 0 or probability_s > 1, BINOM.DIST returns the #NUM! error value.

BINOM.DIST2.png


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-han-shu.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion