MODE.MULT Function in Excel: All the Most Common Values
MODE.MULT returns every value tied for most frequent, where MODE.SNGL returns only the first.
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
NORM.INV Function in Excel: Value for a Given Probability
NORM.INV Function in Excel: Value for a Given Probability
NORM.INV is the reverse of NORM.DIST: give it a probability and it returns the value. Great for safety stock, and for simulations with RAND().
Read article →MODE.SNGL Function in Excel: The Most Frequent Number
MODE.SNGL Function in Excel: The Most Frequent Number
StatisticalLevel: IntermediateAvailable in: Excel 2010+MODE.SNGL returns the value that appears most often in a set of numbers.Syntax=MODE.SNGL(number1.
Read article →PERCENTRANK.INC Function in Excel: Where a Value Stands, as a %
PERCENTRANK.INC Function in Excel: Where a Value Stands, as a %
PERCENTRANK.INC tells you what share of the data is below a value — “this store beats 82% of stores”.
Read article →AVERAGEIF Function in Excel: Average With One Condition
AVERAGEIF Function in Excel: Average With One Condition
StatisticalLevel: IntermediateAvailable in: Excel 2007+AVERAGEIF averages values that meet one condition — often used to ignore.
Read article →QUARTILE.EXC Function in Excel: Quartiles Excluding the Ends
QUARTILE.EXC Function in Excel: Quartiles Excluding the Ends
QUARTILE.EXC matches the method many statistics textbooks and tools use; results differ slightly from QUARTILE.INC on small data.
Read article →PERCENTRANK.EXC Function in Excel: Percentile Position, Excluding Ends
PERCENTRANK.EXC Function in Excel: Percentile Position, Excluding Ends
PERCENTRANK.EXC works like PERCENTRANK.INC, but never returns exactly 0 or 1 — matching the EXC family of percentile functions.
Read article →FREQUENCY Function in Excel: Count Values Into Bins
FREQUENCY Function in Excel: Count Values Into Bins
FREQUENCY counts how many values fall into each bin — the data behind a histogram.
Read article →RANK.EQ Function in Excel: Rank a Number in a List
RANK.EQ Function in Excel: Rank a Number in a List
StatisticalLevel: IntermediateAvailable in: Excel 2010+RANK.EQ returns the position of a number in a list. Ties share the same rank.Syntax=RANK.EQ(number.
Read article →AVERAGEIFS Function in Excel: Average With Multiple Conditions
AVERAGEIFS Function in Excel: Average With Multiple Conditions
StatisticalLevel: IntermediateAvailable in: Excel 2007+AVERAGEIFS averages values where all conditions are true.Syntax=AVERAGEIFS(average_range.
Read article →PERCENTILE.EXC Function in Excel: Percentile Without the End Points
PERCENTILE.EXC Function in Excel: Percentile Without the End Points
PERCENTILE.EXC returns the k-th percentile but treats 0 and 1 as out of range. On small samples its results sit slightly wider than PERCENTILE.INC,…
Read article →RANK Function in Excel: The Old Ranking Function
RANK Function in Excel: The Old Ranking Function
RANK still works for compatibility and behaves exactly like RANK.EQ. New workbooks should use RANK.EQ or RANK.AVG.
Read article →