Related Function:

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

  • This function was introduced in Excel 2013 and so is not available in earlier versions.

Syntax

=SKEW.P(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.P(A2:A12) 0.325432 Skewness of a distribution based on the population 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

  if the function is provided with a reference to a range of cells, any text values within this cell range are simply ignored
#DIV/0! Occurs if either:

  less than 3 data values have been supplied to the function
  the standard deviation of the data points is zero
Other Errors Occur 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:    

    \[    v = \frac 1{n} \sum_{i=1}^n \left( \frac {x_i - \bar{x}}{\sigma} \right)^3    \]

See Wikipedia for more information on skewness.