Menu
EXCEL SKEW.P FUNCTION
Excel SKEW.P Function Introduction
The Excel SKEW.P function computes the skewness of a distribution given a collection of data.
Description of Excel SKEW.P Function
Syntax :
=SKEW.P( number1, [number2], … )
Parameters :
- The number parameters must offer a minimum of three values that comprise the data set. Individual numbers or arrays of numbers can be used.
Step By Step Guide of SKEW.P Function
Example :
The spreadsheet on the right has 15 data values in Column A. The chart below depicts the distribution of these values:
The population skewness of the numbers in the spreadsheet may be computed as follows using the Excel Skew.P Function:
The result is 0.774523929, suggesting that the data set has a positive skew.
Key Points
- #DIV/0! – Occurs when either: less than three data values are submitted to the function; or the standard deviation of the data points is zero.
- #VALUE! – This error occurs if any of the numerical parameters passed directly to the function are not acknowledged as numeric values.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
