Excel functions / Statistics

SKEW.P function

How lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left.

Syntax

=SKEW.P(number1, [number2], …)

Arguments

When to use it

SKEW.P measures how lopsided a whole population is: positive for a long tail to the right. SKEW is the sample version.

Examples

  1. Skew of a population

    ABC
    1Value
    230.303
    34
    45
    52
    63
    74
    85
    96
    104
    117

    In C2: =SKEW.P(A2:A11) → 0.303

    Try this example

Common mistakes

SKEW.P 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.P in the playground

Related functions