BETA.DIST Function in Excel: Probability for Values Between 0 and 1
BETA.DIST gives the beta distribution, used for proportions and task-duration estimates (PERT). With A and B you can rescale it to any range, e.g.…
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
HYPGEOM.DIST Function in Excel: Sampling Without Replacement
HYPGEOM.DIST Function in Excel: Sampling Without Replacement
HYPGEOM.DIST gives the chance of k successes when you draw a sample without putting items back, e.g. defective units found in an inspection sample.
Read article →PROB Function in Excel: Probability From a Table
PROB Function in Excel: Probability From a Table
PROB adds the probabilities of outcomes falling between two limits, from a simple value/probability table.
Read article →NORMSINV Function in Excel: Inverse Standard Normal (Older Name)
NORMSINV Function in Excel: Inverse Standard Normal (Older Name)
NORMSINV returns z for a probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →BINOM.DIST Function in Excel: Chance of Exactly k Successes
BINOM.DIST Function in Excel: Chance of Exactly k Successes
BINOM.DIST handles yes/no events with a fixed chance — defects in a batch, customers who convert.
Read article →CONFIDENCE Function in Excel: Margin of Error (Older Name)
CONFIDENCE Function in Excel: Margin of Error (Older Name)
CONFIDENCE returns the normal margin of error for a mean. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and…
Read article →NORM.DIST Function in Excel: Bell-Curve Probability
NORM.DIST Function in Excel: Bell-Curve Probability
NORM.DIST gives the probability (cumulative) or the curve height (density) of a normal distribution at a value.
Read article →NORMINV Function in Excel: Inverse Normal (Older Name)
NORMINV Function in Excel: Inverse Normal (Older Name)
NORMINV returns the value at a normal probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →CONFIDENCE.T Function in Excel: Margin of Error for Small Samples
CONFIDENCE.T Function in Excel: Margin of Error for Small Samples
CONFIDENCE.T is the margin of error using the t-distribution, correct for small samples (under ~30) where CONFIDENCE.NORM is too narrow.
Read article →NORM.S.INV Function in Excel: Z-Score for a Probability
NORM.S.INV Function in Excel: Z-Score for a Probability
NORM.S.INV returns the z-score for a cumulative probability — where the famous 1.96 comes from.
Read article →MODE Function in Excel: Most Frequent Value (Older Name)
MODE Function in Excel: Most Frequent Value (Older Name)
MODE returns the most frequent number. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →CONFIDENCE.NORM Function in Excel: Margin of Error
CONFIDENCE.NORM Function in Excel: Margin of Error
CONFIDENCE.NORM gives the ± margin around a sample mean for a chosen confidence level.
Read article →