| Description |
VBA Functions |
Worksheet Functions |
| Distribution Fitting |
- |
=DistFit("LogPearson3";Data)
|
| Probability Density Function |
LogPearson3Pdf(x,alpha,beta,gamma) |
=LogPearson3Pdf(alpha;beta;gamma)
=DistPdf("LogPearson3(alpha;beta;gamma)";x)
|
| Cumulative Distribution Function |
LogPearson3Cdf(x,alpha,beta,gamma) |
=LogPearson3Cdf(alpha;beta;gamma)
=DistCdf("LogPearson3(alpha;beta;gamma)";x)
|
| Survival Function |
LogPearson3Surv(x,alpha,beta,gamma) |
=DistSurv("LogPearson3(alpha;beta;gamma)";x)
|
| Hazard Function |
LogPearson3Haz(x,alpha,beta,gamma) |
=LogPearson3Haz(alpha;beta;gamma)
=DistHaz("LogPearson3(alpha;beta;gamma)";x)
|
| Cumulative Hazard Function |
LogPearson3CumHaz(x,alpha,beta,gamma) |
=DistCumHaz("LogPearson3(alpha;beta;gamma)";x)
|
| Inverse CDF (Quantile Function) |
LogPearson3Inv(P,alpha,beta,gamma) |
=LogPearson3Inv(alpha;beta;gamma)
=DistInv("LogPearson3(alpha;beta;gamma)";P)
|
| Random Numbers |
LogPearson3Rand(alpha,beta,gamma) |
=LogPearson3Rand(alpha;beta;gamma)
=DistRand("LogPearson3(alpha;beta;gamma)")
|
| Mode |
LogPearson3Mode(alpha,beta,gamma) |
=DistMode("LogPearson3(alpha;beta;gamma)")
|
| Mean |
LogPearson3Mean(alpha,beta,gamma) |
=LogPearson3Mean(alpha;beta;gamma)
=DistMean("LogPearson3(alpha;beta;gamma)")
|
| Variance |
LogPearson3Var(alpha,beta,gamma) |
=LogPearson3Var(alpha;beta;gamma)
=DistVar("LogPearson3(alpha;beta;gamma)")
|
| Standard Deviation |
LogPearson3Stdev(alpha,beta,gamma) |
=LogPearson3Stdev(alpha;beta;gamma)
=DistStdev("LogPearson3(alpha;beta;gamma)")
|
| Skewness |
LogPearson3Skew(alpha,beta,gamma) |
=DistSkew("LogPearson3(alpha;beta;gamma)")
|
| (Excess) Kurtosis |
LogPearson3Kurt(alpha,beta,gamma) |
=DistKurt("LogPearson3(alpha;beta;gamma)")
|