The SKEW function calculates the skewness of a group of values with an asymmetric tail from its mean value.
Formula in cell D3:
Excel Function Syntax
SKEW(number1, [number2], ...)
Required. This argument can be an array of constants or a cell reference to a group of values.
Optional. Up to 254 additional arguments separated by commas.
Positive skewness implies a group of values with an asymmetric tail moving toward more positive values. Negative skewness implies a group of values with an asymmetric tail moving toward more negative values.
The SKEW function returns #DIV/0! error value if there are less than three numbers to be calculated.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Statistical'
The SKEW function function is one of many functions in the 'Statistical' category.