Description |
VBA Functions |
Worksheet Functions |
Distribution Fitting |
- |
=DistFit("Poisson";Data)
|
Probability Density Function |
PoissonPdf(x,lambda) |
=PoissonPdf(lambda)
=DistPdf("Poisson(lambda)";x)
|
Cumulative Distribution Function |
PoissonCdf(x,lambda) |
=PoissonCdf(lambda)
=DistCdf("Poisson(lambda)";x)
|
Survival Function |
PoissonSurv(x,lambda) |
=DistSurv("Poisson(lambda)";x)
|
Random Numbers |
PoissonRand(lambda) |
=PoissonRand(lambda)
=DistRand("Poisson(lambda)")
|
Mode |
PoissonMode(lambda) |
=DistMode("Poisson(lambda)")
|
Mean |
PoissonMean(lambda) |
=PoissonMean(lambda)
=DistMean("Poisson(lambda)")
|
Variance |
PoissonVar(lambda) |
=PoissonVar(lambda)
=DistVar("Poisson(lambda)")
|
Standard Deviation |
PoissonStdev(lambda) |
=PoissonStdev(lambda)
=DistStdev("Poisson(lambda)")
|
Skewness |
PoissonSkew(lambda) |
=DistSkew("Poisson(lambda)")
|
(Excess) Kurtosis |
PoissonKurt(lambda) |
=DistKurt("Poisson(lambda)")
|