| Description |
VBA Functions |
Worksheet Functions |
| Distribution Fitting |
- |
=DistFit("GenGamma";Data;[Options]1)
|
| Probability Density Function |
GenGammaPdf(x,k,alpha,beta,[gamma]) |
=GenGammaPdf(k;alpha;beta;[gamma])
=DistPdf("GenGamma(k;alpha;beta;[gamma])";x)
|
| Cumulative Distribution Function |
GenGammaCdf(x,k,alpha,beta,[gamma]) |
=GenGammaCdf(k;alpha;beta;[gamma])
=DistCdf("GenGamma(k;alpha;beta;[gamma])";x)
|
| Survival Function |
GenGammaSurv(x,k,alpha,beta,[gamma]) |
=DistSurv("GenGamma(k;alpha;beta;[gamma])";x)
|
| Hazard Function |
GenGammaHaz(x,k,alpha,beta,[gamma]) |
=GenGammaHaz(k;alpha;beta;[gamma])
=DistHaz("GenGamma(k;alpha;beta;[gamma])";x)
|
| Cumulative Hazard Function |
GenGammaCumHaz(x,k,alpha,beta,[gamma]) |
=DistCumHaz("GenGamma(k;alpha;beta;[gamma])";x)
|
| Inverse CDF (Quantile Function) |
GenGammaInv(P,k,alpha,beta,[gamma]) |
=GenGammaInv(k;alpha;beta;[gamma])
=DistInv("GenGamma(k;alpha;beta;[gamma])";P)
|
| Random Numbers |
GenGammaRand(k,alpha,beta,[gamma]) |
=GenGammaRand(k;alpha;beta;[gamma])
=DistRand("GenGamma(k;alpha;beta;[gamma])")
|
| Mode |
GenGammaMode(k,alpha,beta,[gamma]) |
=DistMode("GenGamma(k;alpha;beta;[gamma])")
|
| Mean |
GenGammaMean(k,alpha,beta,[gamma]) |
=GenGammaMean(k;alpha;beta;[gamma])
=DistMean("GenGamma(k;alpha;beta;[gamma])")
|
| Variance |
GenGammaVar(k,alpha,beta,[gamma]) |
=GenGammaVar(k;alpha;beta;[gamma])
=DistVar("GenGamma(k;alpha;beta;[gamma])")
|
| Standard Deviation |
GenGammaStdev(k,alpha,beta,[gamma]) |
=GenGammaStdev(k;alpha;beta;[gamma])
=DistStdev("GenGamma(k;alpha;beta;[gamma])")
|
| Skewness |
GenGammaSkew(k,alpha,beta,[gamma]) |
=DistSkew("GenGamma(k;alpha;beta;[gamma])")
|
| (Excess) Kurtosis |
GenGammaKurt(k,alpha,beta,[gamma]) |
=DistKurt("GenGamma(k;alpha;beta;[gamma])")
|