VAR.S Function in Excel: Variance of a Sample
VAR.S is the square of STDEV.S. You rarely report it directly, but it turns up in forecasting, portfolio risk and quality-control formulas.
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
STDEV.P Function in Excel: Standard Deviation of a Whole Population
STDEV.P Function in Excel: Standard Deviation of a Whole Population
STDEV.P measures spread when your data is the entire group, not a sample. The P version divides by n instead of n−1, so it…
Read article →QUARTILE Function in Excel: Quartiles (Older Name)
QUARTILE Function in Excel: Quartiles (Older Name)
QUARTILE returns the quartile of a data set. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →QUARTILE.INC Function in Excel: Split Data Into Quarters
QUARTILE.INC Function in Excel: Split Data Into Quarters
QUARTILE.INC returns the minimum, the 25th, 50th or 75th percentile, or the maximum. It is the fastest way to see whether a salary band…
Read article →STDEV Function in Excel: Sample Standard Deviation (Older Name)
STDEV Function in Excel: Sample Standard Deviation (Older Name)
STDEV estimates the standard deviation from a sample. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →PERCENTILE Function in Excel: k-th Percentile (Older Name)
PERCENTILE Function in Excel: k-th Percentile (Older Name)
PERCENTILE returns the k-th percentile (inclusive). It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →CORREL Function in Excel: How Strongly Two Things Move Together
CORREL Function in Excel: How Strongly Two Things Move Together
CORREL returns a number between −1 and 1: near 1 means both rise together, near −1 means one falls as the other rises, near…
Read article →PERCENTILE.INC Function in Excel: Value at a Percentile (e.g. 90th)
PERCENTILE.INC Function in Excel: Value at a Percentile (e.g. 90th)
PERCENTILE.INC returns the value below which a given percentage of data falls — for salary bands, delivery-time targets and outliers.
Read article →STDEV.S Function in Excel: How Spread Out Are the Numbers?
STDEV.S Function in Excel: How Spread Out Are the Numbers?
STDEV.S measures how far values typically sit from the average (sample standard deviation). A small value means consistent; a large one means volatile.
Read article →COUNTBLANK Function in Excel: Count Empty Cells
COUNTBLANK Function in Excel: Count Empty Cells
COUNTBLANK counts empty cells — and cells with formulas returning "" — a quick data-completeness check.
Read article →MEDIAN Function in Excel: The Middle Value
MEDIAN Function in Excel: The Middle Value
MEDIAN returns the middle value — more representative than AVERAGE when a few huge values distort the mean (salaries, property prices).
Read article →MIN Function in Excel: Smallest Value in a Range
MIN Function in Excel: Smallest Value in a Range
StatisticalLevel: BeginnerAvailable in: Excel 2007+MIN returns the smallest number in a set of values, ignoring text and blanks.Syntax=MIN(number1.
Read article →