Functions for probability distributions
Available function types are D (density), P (cumulative), or Q (inverse cumulative).
To call a probability function, use the following syntax:
<type><name><tail>(<argument>[,<parameters>])Function types are as follows:
- D
- Density
- P
- Cumulative
- Q
- Inverse cumulative
The following list shows the functions names in alphabetical order:
- BERN
- BETA
- BINOM
- CAUCHY
- CHISQ
- EXP
- F
- FISK
- GAMMA
- GEOM
- HYPER
- LNORM
- LOGIS
- NWW
- NBINOM
- NORM
- NORM3P
- PPOINT
- POIS
- T
- UNIF
- WALD
- WEIBULL
- WILCOX
The tail can be a low tail or a high tail. An empty string stands for a low tail, an _H stands for a high tail.
For example:
- DNORM(x)
- The density function of standard normal distribution
- PNORM(x)
- F(x) for a standard normal distribution
- PNORM_H(x)
- 1- PNORM(x)
- QNORM(p)
- The inverse cumulative standard normal distribution function
- QNORM_H(p)
- 1-QNORM(p)