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
| Argument | Required? | What it does |
|---|---|---|
| number1 | Yes | A number, cell or range. |
| number2, … | No | Up 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)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Measure | Result |
| 2 | Ana | North | 62000 | SKEW.P | 0.5038 |
| 3 | Ben | South | 48500 | SKEW | 0.6530 |
| 4 | Cy | North | 50000 | ||
| 5 | Di | East | 71250 | ||
| 6 | Ed | South | 39800 | ||
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
=SKEW.P(C2:C8) Explain
Common mistakes
- #DIV/0! All the numbers are the same, so there is no spread to measure.
Notes

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.