SKEW.P Function in Excel – calculate Population skewness in Excel

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.

SKEW Function in Excel 1

3 A negative skew in which tail is extended towards left indicates that more values lie above the mean

SKEW Function in Excel 2

 

 

Syntax of SKEW.P Function in Excel:

SKEW.P( number1, [number2], … )

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):

 SKEW.P Function in Excel 3

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

SKEW.P Function in Excel 4

 

Example of SKEW.P Function in Excel (Negatively Skewed in Excel):

SKEW.P Function in Excel 5

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

 SKEW.P Function in Excel 6

previous-small SKEW.P Function in Excel                                                                                                                next_small SKEW.P Function in Excel