Excel Functions
Distributions
| Name | Type | Functions | |||
| Beta | Continuous | BETA.DIST | BETA.INV | ||
| Binomial | Discrete | BINOM.DIST | BINOM.INV | ||
| Binomial Negative | Discrete | NEGBINOM.DIST | |||
| Chi-Squared | Continuous | CHISQ.DIST | CHISQ.INV | CHISQ.DIST.RT | CHISQ.INV.RT |
| Exponential | Continuous | EXPON.DIST | |||
| F | Continuous | F.DIST | F.INV | F.DIST.RT | F.INV.RT |
| Gamma | Continuous | GAMMA.DIST | GAMMA.INV | ||
| Hypergeometric | Discrete | HYPGEOM.DIST | |||
| Lognormal | Continuous | LOGNORM.DIST | LOGNORM.INV | ||
| Normal / Gaussian | Continuous | NORM.DIST | NORM.INV | ||
| NORM.S.DIST | NORM.S.INV | ||||
| Poisson | Discrete | POISSON.DIST | |||
| T | Continuous | T.DIST | T.INV | T.DIST.RT | |
| T.DIST.2T | T.INV.2T | ||||
| Weibull | Continuous | WEIBULL.DIST |
Hypothesis Testing
| CHISQ.TEST | Returns the probability value from a chi-squared distribution. |
| F.TEST | Returns the probability value from an f distribution. |
| T.TEST | Returns the probability value from a t distribution. |
| Z.TEST | Returns the probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
| CHISQ.TEST Returns the probability value from a chi-squared distribution. |
| F.TEST Returns the probability value from an f distribution. |
| T.TEST Returns the probability value from a t distribution. |
| Z.TEST Returns the probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext