Negative Binomial Distribution

Parameters

Domain

Probability Density Function

Cumulative Distribution Function

where is the Binomial Coefficient "a Choose b".

Worksheet and VBA Functions

The following worksheet and VBA functions are available for this distribution:

Description	VBA Functions	Worksheet Functions
Distribution Fitting	-	=DistFit("NegBinomial";Data;[Options]1)
Probability Density Function	NegBinomialPdf(x,n,p)	=NegBinomialPdf(n;p) =DistPdf("NegBinomial(n;p)";x)
Cumulative Distribution Function	NegBinomialCdf(x,n,p)	=NegBinomialCdf(n;p) =DistCdf("NegBinomial(n;p)";x)
Survival Function	NegBinomialSurv(x,n,p)	=DistSurv("NegBinomial(n;p)";x)
Random Numbers	NegBinomialRand(n,p)	=NegBinomialRand(n;p) =DistRand("NegBinomial(n;p)")
Mode	NegBinomialMode(n,p)	=DistMode("NegBinomial(n;p)")
Mean	NegBinomialMean(n,p)	=NegBinomialMean(n;p) =DistMean("NegBinomial(n;p)")
Variance	NegBinomialVar(n,p)	=NegBinomialVar(n;p) =DistVar("NegBinomial(n;p)")
Standard Deviation	NegBinomialStdev(n,p)	=NegBinomialStdev(n;p) =DistStdev("NegBinomial(n;p)")
Skewness	NegBinomialSkew(n,p)	=DistSkew("NegBinomial(n;p)")
(Excess) Kurtosis	NegBinomialKurt(n,p)	=DistKurt("NegBinomial(n;p)")

1. The Options parameter is optional. Possible options: "n=value"  (example: "n=10")