SKEW Function Explained

The SKEW function in Microsoft Excel calculates the skewness of a distribution based on a supplied set of values. Skewness is a measure of asymmetry, or lack of symmetry, in a distribution. The SKEW function returns a value that indicates the degree of asymmetry in the distribution. A positive value indicates a distribution with an asymmetric tail extending toward more positive values. A negative value indicates a distribution with an asymmetric tail extending toward more negative values.

SKEW Function Syntax

SKEW(number1, [number2], ...)

  • number1: The first number, cell reference, or range of cells for which you want to calculate skewness.
  • number2: (optional) Additional numbers, cell references, or ranges of cells for which you want to calculate skewness.