SKEW function
SKEW(First,
Other...) SKEW(First;
Other...)
First
Number or { Number }
The first parameter.
Other
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.