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("Binomial";Data;[Options]1)
Probability Density Function	BinomialPdf(x,n,p)	=BinomialPdf(n;p) =DistPdf("Binomial(n;p)";x)
Cumulative Distribution Function	BinomialCdf(x,n,p)	=BinomialCdf(n;p) =DistCdf("Binomial(n;p)";x)
Survival Function	BinomialSurv(x,n,p)	=DistSurv("Binomial(n;p)";x)
Random Numbers	BinomialRand(n,p)	=BinomialRand(n;p) =DistRand("Binomial(n;p)")
Mode	BinomialMode(n,p)	=DistMode("Binomial(n;p)")
Mean	BinomialMean(n,p)	=BinomialMean(n;p) =DistMean("Binomial(n;p)")
Variance	BinomialVar(n,p)	=BinomialVar(n;p) =DistVar("Binomial(n;p)")
Standard Deviation	BinomialStdev(n,p)	=BinomialStdev(n;p) =DistStdev("Binomial(n;p)")
Skewness	BinomialSkew(n,p)	=DistSkew("Binomial(n;p)")
(Excess) Kurtosis	BinomialKurt(n,p)	=DistKurt("Binomial(n;p)")

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