SKEW.P function
SKEW.P returns the population skewness of your data, showing whether it leans to one side. It works like SKEW but treats the data as the whole population instead of a sample.
Example
Read it as a sentence: measure how lopsided the values in A1:A8 are, treating them as the whole group, which gives 0.65625.
Excel shows 0.65625
A
1
2
2
4
3
4
4
4
5
5
6
5
7
7
8
9
Data
Syntax
SKEW.P(number1, [number2], ...)
Arguments in [square brackets] are optional.
-
number1(required) - First number or range.
-
number2(optional) - More numbers or ranges.
Returns: The population skewness of the data.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=SKEW.P({2,4,4,4,5,5,7,9}) | 0.65625 | Array constant |
=SKEW.P(10,"20",TRUE) | 0.064351267 | Direct args: number, text-number, TRUE |
=SKEW.P(Data!A1:A8) | 0.65625 | Range of numbers |
=SKEW.P(Data!B1:B8) | -0.381801774 | Mixed range: num, text-number, TRUE, blank, text, FALSE |
=SKEW.P(Data!A1:A4,Data!F1:F5) | -0.428931649 | Two ranges |
=SKEW.P(10,"abc") | #VALUE! | Direct arg: non-numeric text |
=SKEW.P(5) | #DIV/0! | Single number |
=SKEW.P({1,"2",TRUE,3}) | #DIV/0! | Array with text and boolean |
The Data sheet these formulas read
A cell that starts with = holds that formula.
A
B
F
1
2
10
1
2
4
20
2
3
4
TRUE
3
4
4
4
5
5
abc
5
6
5
30
7
7
FALSE
8
9
40
Data
Watch out for
- Gives a slightly smaller magnitude than SKEW on the same data.
- Needs at least one value and a nonzero spread.
Where it works
- Excel
- SKEW.P arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .