Excel functions / Statistics
SKEW function
Skewness: how lopsided the data are. Positive means a longer tail of high values, negative a longer tail of low values.
Syntax
=SKEW(number1, [number2], …)
Arguments
number: Numbers, cells or ranges.
When to use it
SKEW measures how lopsided a set of values is: positive when a long tail runs to the right (a few large values), negative when it runs to the left, near 0 when it is balanced. Waiting times and incomes are usually positively skewed.
Examples
Response times
A B C 1 Response (min) 2 3 2.40 3 4 4 4 5 5 6 6 7 30 In C2:
=SKEW(A2:A7)→ 2.40A long tail to the right, so the median says more than the average.
Common mistakes
- Sample or population. SKEW treats the data as a sample. SKEW.P is the population version.
SKEW in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: SKEW
- Danish: SKÆVHED
- Dutch: SCHEEFHEID
- Finnish: JAKAUMAN.VINOUS
- French: COEFFICIENT.ASYMETRIE
- German: SCHIEFE
- Hungarian: FERDESÉG
- Italian: ASIMMETRIA
- Norwegian: SKJEVFORDELING
- Polish: SKOŚNOŚĆ
- Portuguese (Brazil): DISTORÇÃO
- Portuguese (Portugal): DISTORÇÃO
- Russian: СКОС
- Spanish: COEFICIENTE.ASIMETRIA
- Swedish: SNEDHET
- Turkish: ÇARPIKLIK
Practise it
Related functions
- SKEW.P: How lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left.
- KURT: Kurtosis: how heavy the tails are compared with a normal distribution (0). Positive means more extreme values.
- MEDIAN: The middle number of a sorted list.
- AVERAGE: The arithmetic mean of the numbers.