GAMMADIST Function in Excel: Gamma Distribution (Older Name)
GAMMADIST returns the gamma probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
📊
← Excel
Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
📄 148 articles⬇️ 72 with practice files🕒 Updated 13 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →TTEST Function in Excel: t-Test (Older Name)
TTEST Function in Excel: t-Test (Older Name)
TTEST returns the p-value of a t-test between two samples. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and…
Read article →GAMMA.INV Function in Excel: Value for a Gamma Probability
GAMMA.INV Function in Excel: Value for a Gamma Probability
StatisticsLevel: ExpertAvailable in: Excel 2010+GAMMA.INV returns the value at a given gamma probability.Syntax=GAMMA.INV(probability, alpha.
Read article →BINOM.DIST.RANGE Function in Excel: Probability of Successes in a Range
BINOM.DIST.RANGE Function in Excel: Probability of Successes in a Range
BINOM.DIST.RANGE gives the chance of getting between s and s2 successes in n trials, e.g. 3 to 5 sales from 20 calls.
Read article →GAMMA.DIST Function in Excel: Gamma Distribution
GAMMA.DIST Function in Excel: Gamma Distribution
GAMMA.DIST models waiting times and amounts that are always positive and skewed, like claim sizes or repair times.
Read article →ZTEST Function in Excel: z-Test (Older Name)
ZTEST Function in Excel: z-Test (Older Name)
ZTEST returns the one-tailed p-value of a z-test. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →WEIBULL Function in Excel: Weibull (Older Name)
WEIBULL Function in Excel: Weibull (Older Name)
WEIBULL returns the Weibull probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →BETAINV Function in Excel: Inverse Beta (Older Name)
BETAINV Function in Excel: Inverse Beta (Older Name)
BETAINV returns the value at a beta probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →GAUSS Function in Excel: Probability Between the Mean and z
GAUSS Function in Excel: Probability Between the Mean and z
GAUSS returns the probability that a standard normal value falls between the mean and z standard deviations: NORM.S.DIST(z) - 0.5.
Read article →Z.TEST Function in Excel: One-Sample z-Test
Z.TEST Function in Excel: One-Sample z-Test
Z.TEST returns the one-tailed p-value for whether a sample mean is higher than a claimed value.
Read article →PHI Function in Excel: Standard Normal Density
PHI Function in Excel: Standard Normal Density
PHI returns the height of the standard normal curve at z, the same as NORM.S.DIST(z, FALSE).
Read article →WEIBULL.DIST Function in Excel: Weibull Distribution for Failure Times
WEIBULL.DIST Function in Excel: Weibull Distribution for Failure Times
WEIBULL.DIST models time to failure: the chance a machine part fails within x hours.
Read article →