HYPGEOMDIST Function in Excel: Hypergeometric (Older Name)
HYPGEOMDIST returns the probability of k successes when sampling without replacement. It is a compatibility function: Excel keeps it so workbooks from Excel 2007…
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
NEGBINOMDIST Function in Excel: Negative Binomial (Older Name)
NEGBINOMDIST Function in Excel: Negative Binomial (Older Name)
NEGBINOMDIST returns the probability of a number of failures before the k-th success. It is a compatibility function: Excel keeps it so workbooks from…
Read article →CRITBINOM Function in Excel: Binomial Threshold (Older Name)
CRITBINOM Function in Excel: Binomial Threshold (Older Name)
CRITBINOM returns the smallest count whose cumulative binomial probability reaches alpha. It is a compatibility function: Excel keeps it so workbooks from Excel 2007…
Read article →POISSON Function in Excel: Poisson Probability (Older Name)
POISSON Function in Excel: Poisson Probability (Older Name)
POISSON returns the Poisson probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →EXPON.DIST Function in Excel: Waiting-Time Probability
EXPON.DIST Function in Excel: Waiting-Time Probability
EXPON.DIST gives the chance the wait until the next event is under a given time.
Read article →BETA.INV Function in Excel: Value for a Beta Probability
BETA.INV Function in Excel: Value for a Beta Probability
BETA.INV is the reverse of BETA.DIST: for a probability it returns the value, e.g. the duration you will meet 90% of the time.
Read article →NORMSDIST Function in Excel: Standard Normal (Older Name)
NORMSDIST Function in Excel: Standard Normal (Older Name)
NORMSDIST gives the cumulative standard normal probability for z. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier…
Read article →POISSON.DIST Function in Excel: Chance of Rare Events
POISSON.DIST Function in Excel: Chance of Rare Events
POISSON.DIST models counts per interval — calls per minute, breakdowns per month.
Read article →NORM.S.DIST Function in Excel: Standard Normal Probability
NORM.S.DIST Function in Excel: Standard Normal Probability
NORM.S.DIST is NORM.DIST with mean 0 and standard deviation 1 — perfect for z-scores.
Read article →BETADIST Function in Excel: Beta Distribution (Older Name)
BETADIST Function in Excel: Beta Distribution (Older Name)
BETADIST returns the cumulative beta probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →BINOM.INV Function in Excel: Smallest Count Reaching a Probability
BINOM.INV Function in Excel: Smallest Count Reaching a Probability
BINOM.INV returns the smallest number of successes whose cumulative probability reaches the target, e.g. how many defects is 'unusual'.
Read article →STANDARDIZE Function in Excel: Z-Score in One Step
STANDARDIZE Function in Excel: Z-Score in One Step
STANDARDIZE converts a value to a z-score: how many standard deviations it sits from the mean. Z-scores let you compare marks from an easy…
Read article →