Wauvel

Excel like a finance pro.

← The library

Statistical function

SKEW.P

Returns the skewness of a distribution based on a whole population.

Rarely usedDifficulty 1400 · AdvancedUsage rank #358 of 520
Practice · 2 questions →

When to use it

Population skewness, using n rather than the sample correction.

The shape of it

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

Worked examples

  • Right skew

    =SKEW.P(1,2,3,4,10) → 1.138

    Smaller than SKEW on the same values.

  • Symmetric

    =SKEW.P(1,2,3,4,5) → 0

    Symmetric.

  • Full population

    =SKEW.P(B2:B101) → 2.36

    Order sizes across all orders in the period.

Worth knowing

  • Use only when the data is the whole population.
  • The sample version SKEW is larger by a factor that shrinks as n grows.
  • Introduced in Excel 2013.

Where it goes wrong

  • #DIV/0! with fewer than three values or zero sd.
  • #NAME? in Excel 2010 and earlier.

Related

AVERAGECOUNTCOUNTACOUNTIFCOUNTIFSMAX

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.