SKEW.P Function

Returns the skewness of an entire population.

Category

Statistical

Available in

Excel 2013+, Microsoft 365

Returns

A number

Want to practice SKEW.P in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

SKEW.P measures how lopsided the data is, treating the numbers as the whole population. Like SKEW, 0 is symmetrical, positive means a long high tail and negative a long low tail.

SKEW uses a small-sample correction, so its result is a little further from 0 than SKEW.P's.

Syntax

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

Arguments

ArgumentRequired?What it does
number1YesA number, cell or range.
number2, …NoUp to 254 more numbers, cells or ranges.

Examples

Example 1 — Population vs. sample skewness

The whole sales team, then the same data treated as a sample.

E2fx=SKEW.P(C2:C8)
ABCDE
1RepRegionSalesMeasureResult
2AnaNorth62000SKEW.P0.5038
3BenSouth48500SKEW0.6530
4CyNorth50000
5DiEast71250
6EdSouth39800
7FayNorth55400
8GusEast48500
=SKEW.P(C2:C8) Explain

Common mistakes

  • #DIV/0! All the numbers are the same, so there is no spread to measure.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.