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.
=SKEW.P(num_1,[num_2], … )
|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|
|2||3||=SKEW.P(A2:A12)||0.325432||Skewness of a distribution based on the population of the data set in A2:A12|
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:
|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:
See Wikipedia for more information on skewness.