| Description |
VBA Functions |
Worksheet Functions |
| Distribution Fitting |
- |
=DistFit("Burr";Data;[Options]1)
|
| Probability Density Function |
BurrPdf(x,k,alpha,beta,[gamma]) |
=BurrPdf(k;alpha;beta;[gamma])
=DistPdf("Burr(k;alpha;beta;[gamma])";x)
|
| Cumulative Distribution Function |
BurrCdf(x,k,alpha,beta,[gamma]) |
=BurrCdf(k;alpha;beta;[gamma])
=DistCdf("Burr(k;alpha;beta;[gamma])";x)
|
| Survival Function |
BurrSurv(x,k,alpha,beta,[gamma]) |
=DistSurv("Burr(k;alpha;beta;[gamma])";x)
|
| Hazard Function |
BurrHaz(x,k,alpha,beta,[gamma]) |
=BurrHaz(k;alpha;beta;[gamma])
=DistHaz("Burr(k;alpha;beta;[gamma])";x)
|
| Cumulative Hazard Function |
BurrCumHaz(x,k,alpha,beta,[gamma]) |
=DistCumHaz("Burr(k;alpha;beta;[gamma])";x)
|
| Inverse CDF (Quantile Function) |
BurrInv(P,k,alpha,beta,[gamma]) |
=BurrInv(k;alpha;beta;[gamma])
=DistInv("Burr(k;alpha;beta;[gamma])";P)
|
| Random Numbers |
BurrRand(k,alpha,beta,[gamma]) |
=BurrRand(k;alpha;beta;[gamma])
=DistRand("Burr(k;alpha;beta;[gamma])")
|
| Mode |
BurrMode(k,alpha,beta,[gamma]) |
=DistMode("Burr(k;alpha;beta;[gamma])")
|
| Mean |
BurrMean(k,alpha,beta,[gamma]) |
=BurrMean(k;alpha;beta;[gamma])
=DistMean("Burr(k;alpha;beta;[gamma])")
|
| Variance |
BurrVar(k,alpha,beta,[gamma]) |
=BurrVar(k;alpha;beta;[gamma])
=DistVar("Burr(k;alpha;beta;[gamma])")
|
| Standard Deviation |
BurrStdev(k,alpha,beta,[gamma]) |
=BurrStdev(k;alpha;beta;[gamma])
=DistStdev("Burr(k;alpha;beta;[gamma])")
|
| Skewness |
BurrSkew(k,alpha,beta,[gamma]) |
=DistSkew("Burr(k;alpha;beta;[gamma])")
|
| (Excess) Kurtosis |
BurrKurt(k,alpha,beta,[gamma]) |
=DistKurt("Burr(k;alpha;beta;[gamma])")
|