SKEW.P

Calculates the population skewness of the values in a data set.

This is a measure of the asymmetry of a distribution of values about their mean.

Syntax:

SKEW.P( list )

Returns the population skewness of the values in the list.

list may be a range of cells, an array, or a comma-separated list of values (which may contain cell references and also ranges of cells as one or more of its elements).

Example:

SKEW.P(A1:A15)

returns the population skewness of the contents of cells in the range A1:A15.

Note:

SKEW.P() is implemented using a two-pass approach, first independently computing the mean value, then computing intermediate values (such as the sum of the squares, products) using the difference between each value and the mean value. This approach helps avoid many round-off errors and is also employed by Microsoft Excel 2003 and later.