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: