SKEW(list)

The SKEW function calculates the skewness of a distribution given by list.

Skewness is a measure of the asymmetery of a distribution round its mean. A distribution with positive skewness has an asymmetric tail that stretches towards more positive values. A distribution with negative skewness has an asymmetric tail that stretches towards more negative values.

SKEW works with a list of numbers, a range or an array. An error message is returned if there are less than 3 values.

For example:

SKEW(16, 17, 19, 12, 11, 10, 9)

returns 0.367654.

See also:

Other statistical functions