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: