SKEW.P Function in Excel: Skewness of a Population
SKEW.P measures lopsidedness of a complete data set; SKEW is the sample version.
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
SKEW Function in Excel: Is the Data Lopsided?
SKEW Function in Excel: Is the Data Lopsided?
SKEW is positive when a long tail stretches to the right — typical for salaries and order values, where a few big ones pull…
Read article →COVARIANCE.S Function in Excel: Do Two Series Move Together?
COVARIANCE.S Function in Excel: Do Two Series Move Together?
COVARIANCE.S measures whether two variables rise and fall together. Its size depends on units, so CORREL is easier to read.
Read article →MAXA Function in Excel: Largest Value, Logicals Included
MAXA Function in Excel: Largest Value, Logicals Included
StatisticsLevel: IntermediateAvailable in: Excel 2007+MAXA is MAX that counts TRUE as 1 and text as 0.Syntax=MAXA(value1, [value2], ...)ArgumentWhat it.
Read article →AVERAGEA Function in Excel: Average Counting Text as Zero
AVERAGEA Function in Excel: Average Counting Text as Zero
AVERAGEA treats text as 0 and TRUE as 1. Use it when “absent” should drag the average down rather than be ignored.
Read article →MINIFS Function in Excel: Smallest Value Meeting Conditions
MINIFS Function in Excel: Smallest Value Meeting Conditions
StatisticalLevel: IntermediateAvailable in: Excel 2019+MINIFS returns the minimum of values where all conditions are true.Syntax=MINIFS(min_range.
Read article →MAXIFS Function in Excel: Largest Value Meeting Conditions
MAXIFS Function in Excel: Largest Value Meeting Conditions
MAXIFS returns the maximum of values where all conditions are met; MINIFS returns the minimum.
Read article →PERMUT Function in Excel: Arrangements Where Order Matters
PERMUT Function in Excel: Arrangements Where Order Matters
PERMUT counts ordered arrangements — podium positions, codes without repeated digits.
Read article →FISHERINV Function in Excel: Back From Fisher’s z to a Correlation
FISHERINV Function in Excel: Back From Fisher’s z to a Correlation
StatisticsLevel: ExpertAvailable in: Excel 2007+FISHERINV reverses FISHER, turning z back into a correlation.Syntax=FISHERINV(y)ArgumentWhat it.
Read article →FISHER Function in Excel: Fisher Transformation of a Correlation
FISHER Function in Excel: Fisher Transformation of a Correlation
FISHER transforms a correlation coefficient so it is roughly normal, which lets you build confidence intervals and compare correlations.
Read article →VARA Function in Excel: Sample Variance Counting Text and TRUE/FALSE
VARA Function in Excel: Sample Variance Counting Text and TRUE/FALSE
StatisticsLevel: IntermediateAvailable in: Excel 2007+VARA is VAR.S that counts text as 0 and TRUE as 1.Syntax=VARA(value1, [value2], ...)ArgumentWhat it.
Read article →STDEVP Function in Excel: Population Standard Deviation (Older Name)
STDEVP Function in Excel: Population Standard Deviation (Older Name)
STDEVP gives the standard deviation of a whole population. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier…
Read article →