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 →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
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 →CHOOSEROWS Function in Excel: Pick Specific Rows
CHOOSEROWS Function in Excel: Pick Specific Rows
CHOOSEROWS returns the rows you specify — first, last, or any list of positions.
Read article →HYPGEOMDIST Function in Excel: Hypergeometric (Older Name)
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 →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 →CHOOSECOLS Function in Excel: Pick Specific Columns
CHOOSECOLS Function in Excel: Pick Specific Columns
Dynamic ArrayLevel: ExpertAvailable in: Excel 365 / 2021+CHOOSECOLS returns only the columns you list, in the order you list them.Syntax=CHOOSECOLS(array.
Read article →ERF Function in Excel: Error Function
ERF Function in Excel: Error Function
ERF returns the error function between 0 and x (or between two limits), used in probability and diffusion.
Read article →