LOGNORM.DIST Function in Excel: Lognormal Distribution
LOGNORM.DIST models values whose logarithm is normal: incomes, house prices, stock prices, file sizes.
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
LOGNORM.INV Function in Excel: Value for a Lognormal Probability
LOGNORM.INV Function in Excel: Value for a Lognormal Probability
StatisticsLevel: ExpertAvailable in: Excel 2010+LOGNORM.INV returns the value at a lognormal probability.Syntax=LOGNORM.INV(probability, mean.
Read article →TRIMMEAN Function in Excel: Average That Ignores Extremes
TRIMMEAN Function in Excel: Average That Ignores Extremes
TRIMMEAN drops a share of the highest and lowest values and averages the rest, much like judges scoring gymnastics. One giant order stops distorting…
Read article →COVARIANCE.P Function in Excel: Covariance of a Whole Population
COVARIANCE.P Function in Excel: Covariance of a Whole Population
COVARIANCE.P measures how two complete data sets move together, dividing by n (COVARIANCE.S divides by n-1).
Read article →STDEVPA Function in Excel: Population SD Counting Text and TRUE/FALSE
STDEVPA Function in Excel: Population SD Counting Text and TRUE/FALSE
StatisticsLevel: IntermediateAvailable in: Excel 2007+STDEVPA is the population version of STDEVA.Syntax=STDEVPA(value1, [value2], ...)ArgumentWhat it.
Read article →VARP Function in Excel: Population Variance (Older Name)
VARP Function in Excel: Population Variance (Older Name)
VARP gives the variance of a whole population. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →VARPA Function in Excel: Population Variance Counting Text and TRUE/FALSE
VARPA Function in Excel: Population Variance Counting Text and TRUE/FALSE
StatisticsLevel: IntermediateAvailable in: Excel 2007+VARPA is the population version of VARA.Syntax=VARPA(value1, [value2], ...)ArgumentWhat it.
Read article →AVEDEV Function in Excel: Average Distance From the Mean
AVEDEV Function in Excel: Average Distance From the Mean
AVEDEV is the average of absolute deviations — an easier-to-explain measure of spread than standard deviation (“on average we are off by 12 units”).
Read article →DEVSQ Function in Excel: Sum of Squared Deviations
DEVSQ Function in Excel: Sum of Squared Deviations
DEVSQ adds up how far each value is from the mean, squared. It is the raw ingredient of variance and of ANOVA tables.
Read article →VAR.P Function in Excel: Variance of a Whole Population
VAR.P Function in Excel: Variance of a Whole Population
VAR.P is the population version of VAR.S: it divides by n, not n−1. Use it when the data is everything there is — all…
Read article →VAR Function in Excel: Sample Variance (Older Name)
VAR Function in Excel: Sample Variance (Older Name)
VAR estimates variance from a sample. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →KURT Function in Excel: How Heavy Are the Tails?
KURT Function in Excel: How Heavy Are the Tails?
KURT measures whether data has more extreme values than a normal distribution (positive) or fewer (negative).
Read article →