:"Understanding the NEGBINOMDIST function and its applications"-Table skills免费ppt模版下载-道格办公

"Understanding the NEGBINOMDIST function and its applications"

```html

Picture and text skills
Case

Returns the negative binomial distribution.

When the success probability is a constant probability_s, the function NEGBINOMDIST returns the occurrence of number_f before reaching number_s successes

The probability of failure. This function is similar to the binomial distribution, except that it has a fixed number of successes and a variable total number of trials. Similar to the binomial distribution,

The number of trials is assumed to be the independent variable. For example, if you are looking for 10 people who are responsive, and the probability of a candidate with this trait is known to be 0.3. Letter

Number NEGBINOMDIST will calculate the probability that a given number of unqualified candidates will need to be interviewed before 10 qualified candidates are found.

Syntax
NEGBINOMDIST(number_f,number_s,probability_s)

Number_f Number of failures.

Number_s The limit number of successes.

Probability_s Probability of success.

Description

Number_f and number_s will be truncated.

If any parameter is non-numeric, NEGBINOMDIST returns the #VALUE! error value.

if probability_s

If number_f < 0 or number_s < 1, NEGBINOMDIST 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/li-jie-NEGBINOMDIST-han-shu-ji-qi-ying-yong.html