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.

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

 SKEW Function in Excel 3

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

SKEW Function in Excel 4

 

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

SKEW Function in Excel 5

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

SKEW Function in Excel 6

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