Description |
VBA Functions |
Worksheet Functions |
Distribution Fitting |
- |
=DistFit("Pearson5";Data;[Options] 1)
|
Probability Density Function |
Pearson5Pdf(x,alpha,beta,[gamma]) |
=Pearson5Pdf(alpha;beta;[gamma])
=DistPdf("Pearson5(alpha;beta;[gamma])";x)
|
Cumulative Distribution Function |
Pearson5Cdf(x,alpha,beta,[gamma]) |
=Pearson5Cdf(alpha;beta;[gamma])
=DistCdf("Pearson5(alpha;beta;[gamma])";x)
|
Survival Function |
Pearson5Surv(x,alpha,beta,[gamma]) |
=DistSurv("Pearson5(alpha;beta;[gamma])";x)
|
Hazard Function |
Pearson5Haz(x,alpha,beta,[gamma]) |
=Pearson5Haz(alpha;beta;[gamma])
=DistHaz("Pearson5(alpha;beta;[gamma])";x)
|
Cumulative Hazard Function |
Pearson5CumHaz(x,alpha,beta,[gamma]) |
=DistCumHaz("Pearson5(alpha;beta;[gamma])";x)
|
Inverse CDF (Quantile Function) |
Pearson5Inv(P,alpha,beta,[gamma]) |
=Pearson5Inv(alpha;beta;[gamma])
=DistInv("Pearson5(alpha;beta;[gamma])";P)
|
Random Numbers |
Pearson5Rand(alpha,beta,[gamma]) |
=Pearson5Rand(alpha;beta;[gamma])
=DistRand("Pearson5(alpha;beta;[gamma])")
|
Mode |
Pearson5Mode(alpha,beta,[gamma]) |
=DistMode("Pearson5(alpha;beta;[gamma])")
|
Mean |
Pearson5Mean(alpha,beta,[gamma]) |
=Pearson5Mean(alpha;beta;[gamma])
=DistMean("Pearson5(alpha;beta;[gamma])")
|
Variance |
Pearson5Var(alpha,beta,[gamma]) |
=Pearson5Var(alpha;beta;[gamma])
=DistVar("Pearson5(alpha;beta;[gamma])")
|
Standard Deviation |
Pearson5Stdev(alpha,beta,[gamma]) |
=Pearson5Stdev(alpha;beta;[gamma])
=DistStdev("Pearson5(alpha;beta;[gamma])")
|
Skewness |
Pearson5Skew(alpha,beta,[gamma]) |
=DistSkew("Pearson5(alpha;beta;[gamma])")
|
(Excess) Kurtosis |
Pearson5Kurt(alpha,beta,[gamma]) |
=DistKurt("Pearson5(alpha;beta;[gamma])")
|