# 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. 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:

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

####   