# SKEW

Formulas / SKEW
Calculate the skewness of a distribution.
`SKEW(number1, [number2], ...)`
• number1 - required numeric value or array of values
• number2 - [OPTIONAL] numeric value or array of values

## Examples

• =SKEW(B5:B15)

The SKEW function can be used to calculate the degree of skewness of a given set of data. This is useful for determining the distribution of the data and whether it is skewed to one side. For example, if we have 11 numeric values in group A and the count of values in group B is the inverse of the values in group A, we can use the SKEW function to calculate the degree of skewness. This would return a value of 0.8924.

• `=SKEW(C5:C15)`

We can also use the SKEW function to calculate the degree of skewness of a given set of data when the count of values in group A is the inverse of the values in group B, which would return a value of -0.8924.

## Summary

The SKEW function calculates the skewness of a distribution by taking numerical, array, and reference to array arguments. Skewness is positive when the distribution has an asymmetric tail extending towards more positive values, or negative when the distribution has an asymmetric tail extending towards more negative values.

• The SKEW function takes a reference or range as its first argument, and optionally a second argument to measure the symmetry of a data set. It returns a positive or negative value.
• The SKEW function requires a range or reference of numeric values as its argument(s). 