SKEW function

SKEW(First, Other...) SKEW(First; Other...)


Number or { Number }

The first parameter.


Number or { Number } (accepts many)

Additional parameters.



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.


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 documentation, licensed under the Apache License 2.0.