Author: Oscar Cronquist Article last updated on August 27, 2018

The SKEW function calculates the skewness of a group of values with an asymmetric tail from its mean value.

Formula in cell D3:

=SKEW(B3:B17)

Excel Function Syntax

SKEW(number1, [number2], ...)

Arguments

number1 Required. This argument can be an array of constants or a cell reference to a group of values.
[number2] Optional. Up to 254 additional arguments separated by commas.

Comments

Positive skewness implies a group of values with an asymmetric tail moving toward more positive values.  Negative skewness implies a group of values with an asymmetric tail moving toward more negative values.

The SKEW function returns #DIV/0! error value if there are less than three numbers to be calculated.

Formula equation