- 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.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.
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
评论列表(196条)
测试