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:    

    \[    \frac n{(n-1)(n-2)} \sum \left( \frac {x_i - \bar{x}}{s} \right)^3    \]

See Wikipedia for more information on skewness.