Related Function:

The SKEW function returns the skewness of the distribution of a supplied set of values.

### Syntax

=SKEW(num_1,[num_2], … )

#### Arguments

Argument Description
num_1 The first number, cell reference, or range for which you want the skew
[num_2], … Optional. Additional numbers, cell references or ranges for which you want the skew, up to a maximum of 255

#### Examples

A B C D E
1 Data   Formula Result Notes
2 3   =SKEW(A2:A12) 0.37924 Skewness of a distribution of the data set in A2:A12
3 5
4 4
5 3
6 2
7 5
8 4
9 7
10 6
11 4
12 2

#### Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied number arguments that are supplied directly to the function are not recognized as numeric values
#DIV/0! Occurs if either:

 • less than 3 data values have been supplied to the function • the sample standard deviation of the supplied data values is zero
Other Errors Occurs if any of the input arguments are error values – the function returns that error

The skewness of a data set is a measurement of the degree of asymmetry of a distribution around its mean.

• Zero skewness indicates perfect symmetry.
• Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values.
• Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.

The equation for skewness is defined as: