Manuals/calci/NEGBINOMDIS

From ZCubes Wiki
Jump to navigation Jump to search

NEGBINOMDIST(nf,ns,ps)

Where nf   is number of failures,ns   is the threshold number of successes and ps  is the probability of a success.


It calculates the negative binomial distribution.


·          nf and ns  are integers.

·          NEGBINOMDIST displays error , when any argument is nonnumeric.

·          The equation for the negative binomial distribution is:

where:

x is nf, r is ns, and p is ps.


NEGBINOMDIS 

Let’s see an example in (Column1 Row 1, Column1Row2, Column1Row3)

NEGBINOMDIST (C1R1, C1R2, C1R3)

i.e. NEGBINOMDIST (15,7,0.5) is 0.0129


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 15
Row2 7
Row3 0.5
Row4 0.0129
Row5
Row6
'