GAMMALN.PRECISE Function in Excel: Natural Log of Gamma (2010+ Version)
GAMMALN.PRECISE is the 2010 version of GAMMALN with the same result and improved accuracy.
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
GAMMA Function in Excel: The Gamma Function
GAMMA Function in Excel: The Gamma Function
StatisticsLevel: ExpertAvailable in: Excel 2013+GAMMA extends factorials to non-whole numbers: GAMMA(n) = (n-1)! for whole.
Read article →MINA Function in Excel: Minimum Counting Text and TRUE/FALSE
MINA Function in Excel: Minimum Counting Text and TRUE/FALSE
StatisticsLevel: IntermediateAvailable in: Excel 2007+MINA is MIN that also counts text as 0 and TRUE as 1, FALSE as 0.Syntax=MINA(value1, [value2].
Read article →GAMMALN Function in Excel: Natural Log of the Gamma Function
GAMMALN Function in Excel: Natural Log of the Gamma Function
GAMMALN returns ln(GAMMA(x)); useful when GAMMA itself would overflow for large x.
Read article →HARMEAN Function in Excel: The Right Average for Rates
HARMEAN Function in Excel: The Right Average for Rates
HARMEAN averages rates properly. Drive 60 km/h one way and 40 km/h back, and your average speed is 48, not 50.
Read article →GEOMEAN Function in Excel: Average Growth Rate
GEOMEAN Function in Excel: Average Growth Rate
GEOMEAN multiplies values and takes the n-th root. For growth rates it gives the honest average: +50% followed by −50% is not an average…
Read article →COVAR Function in Excel: Covariance (Older Name)
COVAR Function in Excel: Covariance (Older Name)
COVAR returns the population covariance. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →TDIST Function in Excel: Student’s t Probability (Older Name)
TDIST Function in Excel: Student’s t Probability (Older Name)
TDIST gives a one- or two-tailed t probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →T.DIST.2T Function in Excel: Two-Tailed t-Test p-Value
T.DIST.2T Function in Excel: Two-Tailed t-Test p-Value
T.DIST.2T turns a t statistic into a two-tailed p-value, the usual one for 'is there any difference?'.
Read article →T.DIST.RT Function in Excel: One-Tailed t p-Value (Right)
T.DIST.RT Function in Excel: One-Tailed t p-Value (Right)
StatisticsLevel: ExpertAvailable in: Excel 2010+T.DIST.RT gives the right-tailed t probability, for 'is it greater?' tests.Syntax=T.DIST.RT(x.
Read article →CHIINV Function in Excel: Chi-Square Critical Value (Older Name)
CHIINV Function in Excel: Chi-Square Critical Value (Older Name)
CHIINV returns the chi-square critical value. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →STDEVA Function in Excel: Sample SD Counting Text and TRUE/FALSE
STDEVA Function in Excel: Sample SD Counting Text and TRUE/FALSE
STDEVA is STDEV.S that also counts text as 0 and TRUE as 1; STDEV.S ignores them.
Read article →