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

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

  1. Response times

    ABC
    1Response (min)
    232.40
    34
    44
    55
    66
    730

    In C2: =SKEW(A2:A7) → 2.40

    A long tail to the right, so the median says more than the average.

    Try this example

Common mistakes

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.

Translate a whole formula

Try SKEW in the playground

Practise it

Related functions