| 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)")
|