Excel functions / Statistics
SKEW.P function
How lopsided a whole population is: positive when the tail runs to the right, negative when it runs to the left.
Syntax
=SKEW.P(number1, [number2], …)
Arguments
number: Numbers, cells or ranges.
When to use it
SKEW.P measures how lopsided a whole population is: positive for a long tail to the right. SKEW is the sample version.
Examples
Skew of a population
A B C 1 Value 2 3 0.303 3 4 4 5 5 2 6 3 7 4 8 5 9 6 10 4 11 7 In C2:
=SKEW.P(A2:A11)→ 0.303
Common mistakes
- Fewer than three values. Skew needs at least three numbers.
SKEW.P in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: SKEW.P
- Danish: SKÆVHED.P
- Dutch: SCHEEFHEID.P
- Finnish: JAKAUMAN.VINOUS.POP
- French: COEFFICIENT.ASYMETRIE.P
- German: SCHIEFE.P
- Hungarian: FERDESÉG.P
- Italian: ASIMMETRIA.P
- Norwegian: SKJEVFORDELING.P
- Polish: SKOŚNOŚĆ.P
- Portuguese (Brazil): DISTORÇÃO.P
- Portuguese (Portugal): DISTORÇÃO.P
- Russian: СКОС.Г
- Spanish: COEFICIENTE.ASIMETRIA.P
- Swedish: SNEDHET.P
- Turkish: ÇARPIKLIK.P