The Excel SKEW.P function calculates the skewness of the distribution of a supplied set of values.
Note: the Skew.P function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.
The syntax of the function is:
Where the number arguments provide a minimum of 3 values that make up the data set. These can be individual numbers or arrays of numbers.
Column A of the above spreadsheet on the right shows 15 data values. The distribution of these values is shown in the chart below:
The population skewness of the values in the spreadsheet can be calculated using the Excel Skew.P Function as follows:
This gives the result 0.774523929, indicating that the data set has a positive skew.
For further details and examples of the Excel Skew.P function, see the Microsoft Office website.
If you get an error from the Excel Skew.P function this is likely to be one of the following:
|#VALUE!||-||(Note that if the Skew.P function is provided with a reference to a range of cells, any text values within this cell range are simply ignored and do not cause the function to return an error).|