SKEW.P Function in Excel calculates the skewness of the population of a supplied set of values.
Definition of Skewness:
The Skew of a data set is a measurement of the asymmetry of the distribution about the mean
1 A skew of zero indicates perfect symmetry
2 A positive skew in which tail is extended towards right indicates that more values lie below the mean.
3 A negative skew in which tail is extended towards left indicates that more values lie above the mean
Syntax of SKEW.P Function in Excel:
Where the number arguments are the population value for which you want to find the skewness.
Example of SKEW.P Function in Excel (Positively Skewed in Excel):
Column A has a distribution of values. Skewness these values can be calculated using formula
=SKEW.P( A2:A16 )
as shown in the above example. This result in the value of 1.098998. Which indicates positive skew.
The Values are positively skewed as shown below
Example of SKEW.P Function in Excel (Negatively Skewed in Excel):
Column A has a distribution of values. Skewness these values can be calculated using formula
=SKEW.P( A2:A17 )
as shown in the above example. This result in the value of – 0.70439 which indicates negative skew.
The Values are negatively skewed as shown below