SKEW function

SKEW(firstParameter, otherParameters...) SKEW(firstParameter; otherParameters...)

firstParameter — Number or { Number }

The first parameter.

otherParameters — Number or { Number } (accepts many)

Additional parameters.

Returns — Number

A measure of how skewed a distribution is.

Returns a measure of how skewed a distribution is, represented by the given parameters. Skewness is a measure of the asymmetry of a distribution around its mean. Use KURT to determine how peaked or flat a distribution is. Use SKEW.P to determine how skewed a distribution is based on a population.

Examples

SKEW(1, 3, 4, 5, 9)SKEW(1; 3; 4; 5; 9)

Returns roughly 0.885, indicating that the tail of this distribution inclines to the positive.

SKEW(1, 3, 4, 5, 7)SKEW(1; 3; 4; 5; 7)

Returns 0, indicating a symmetric distribution.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.