# SKEW Function in Excel – Calculate the skewness of the Distribution

SKEW Function in Excel calculates the skewness of the distribution 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 Function in Excel:

SKEW( number1, [number2], … )

Where the number arguments are the distribution value for which you want to find the skewness.

#### Example of SKEW Function in Excel (Positively Skewed in Excel): Column A has a distribution of values. Skewness these values can be calculated using formula

=SKEW( A2:A16 )

as shown in the above example. This result in the value of 1.2250765. which indicates positive skew.

The Values are positively skewed as shown below #### Example of SKEW Function in Excel (Negatively Skewed in Excel): Column A has a distribution of values. Skewness these values can be calculated using formula

=SKEW( A2:A17 )

as shown in the above example. This result in the value of – 0.77945 which indicates negative skew.

The Values are negatively skewed as shown below 