Description |
VBA Functions |
Worksheet Functions |
Distribution Fitting |
- |
=DistFit("Bernoulli";Data)
|
Probability Density Function |
BernoulliPdf(x,p) |
=BernoulliPdf(p)
=DistPdf("Bernoulli(p)";x)
|
Cumulative Distribution Function |
BernoulliCdf(x,p) |
=BernoulliCdf(p)
=DistCdf("Bernoulli(p)";x)
|
Survival Function |
BernoulliSurv(x,p) |
=DistSurv("Bernoulli(p)";x)
|
Random Numbers |
BernoulliRand(p) |
=BernoulliRand(p)
=DistRand("Bernoulli(p)")
|
Mode |
BernoulliMode(p) |
=DistMode("Bernoulli(p)")
|
Mean |
BernoulliMean(p) |
=BernoulliMean(p)
=DistMean("Bernoulli(p)")
|
Variance |
BernoulliVar(p) |
=BernoulliVar(p)
=DistVar("Bernoulli(p)")
|
Standard Deviation |
BernoulliStdev(p) |
=BernoulliStdev(p)
=DistStdev("Bernoulli(p)")
|
Skewness |
BernoulliSkew(p) |
=DistSkew("Bernoulli(p)")
|
(Excess) Kurtosis |
BernoulliKurt(p) |
=DistKurt("Bernoulli(p)")
|