Description |
VBA Functions |
Worksheet Functions |
Distribution Fitting |
- |
=DistFit("ErrFunc";Data)
|
Probability Density Function |
ErrFuncPdf(x,h) |
=ErrFuncPdf(h)
=DistPdf("ErrFunc(h)";x)
|
Cumulative Distribution Function |
ErrFuncCdf(x,h) |
=ErrFuncCdf(h)
=DistCdf("ErrFunc(h)";x)
|
Survival Function |
ErrFuncSurv(x,h) |
=DistSurv("ErrFunc(h)";x)
|
Hazard Function |
ErrFuncHaz(x,h) |
=ErrFuncHaz(h)
=DistHaz("ErrFunc(h)";x)
|
Cumulative Hazard Function |
ErrFuncCumHaz(x,h) |
=DistCumHaz("ErrFunc(h)";x)
|
Inverse CDF (Quantile Function) |
ErrFuncInv(P,h) |
=ErrFuncInv(h)
=DistInv("ErrFunc(h)";P)
|
Random Numbers |
ErrFuncRand(h) |
=ErrFuncRand(h)
=DistRand("ErrFunc(h)")
|
Mode |
ErrFuncMode(h) |
=DistMode("ErrFunc(h)")
|
Mean |
ErrFuncMean(h) |
=ErrFuncMean(h)
=DistMean("ErrFunc(h)")
|
Variance |
ErrFuncVar(h) |
=ErrFuncVar(h)
=DistVar("ErrFunc(h)")
|
Standard Deviation |
ErrFuncStdev(h) |
=ErrFuncStdev(h)
=DistStdev("ErrFunc(h)")
|
Skewness |
ErrFuncSkew(h) |
=DistSkew("ErrFunc(h)")
|
(Excess) Kurtosis |
ErrFuncKurt(h) |
=DistKurt("ErrFunc(h)")
|