The Excel SKEW.P function returns the skewness of a distribution based on a population — a measure of the asymmetry of data around its mean, treating the data as the entire population rather than a sample.
Syntax
| Argument | Description | |
|---|---|---|
number1 | Required | The first number, array, or range to include. At least three data points are required. |
number2, ... | Optional | Up to 254 additional numbers, arrays, or ranges. |
How to use it
SKEW.P measures the asymmetry of a distribution using the population formula. As with SKEW, a positive result means a right-leaning tail, a negative result a left-leaning tail, and a value near zero a symmetric shape.
The only difference from SKEW is the divisor: SKEW.P divides by n (population), while SKEW applies the (n-1)(n-2) sample correction. For the same data SKEW.P therefore returns a slightly smaller magnitude.
When to use SKEW.P: use it when your data represents the complete population. If the data is a sample drawn from a larger group, use SKEW instead.
Try it: interactive demo
Pick a SKEW.P example to see the formula and its result.
Practice workbook
Frequently asked questions
What is the difference between SKEW.P and SKEW?
When should I use SKEW.P instead of SKEW?
Which Excel versions have SKEW.P?
How many data points does SKEW.P need?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class