Menu
EXCEL SKEW FUNCTION
Excel SKEW Function Introduction
The Excel SKEW function computes the skewness of a distribution given a collection of numbers.
Description of Excel SKEW Function
Syntax :
=SKEW( number1, [number2], … )
Parameters :
- The number parameters offer at least three numeric values that comprise the data collection.
Step By Step Guide of SKEW Function
Example :
The worksheet on the right has 15 data values in Column A. The chart below depicts the distribution of these values:
The skewness of the values in the spreadsheet may be computed as follows using the Excel Skew Function:
=SKEW( A1:A15 )
The result is 0.863378312, suggesting that the set of data has a positive sign.
Key Points
- #DIV/0! – Occurs if one of the following conditions is met: the function has received fewer than three data values; or the average variance extracted of the supplied data values is zero.
- #VALUE! – Occurs if any of the provided number parameters to the Skew function are not accepted 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
