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

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