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).

Frequently Asked Questions

What is the SKEW function?
The SKEW function calculates the skewness of a distribution. Skewness describes the degree of asymmetry of a distribution around its mean. The SKEW function takes numerical, array, and reference arguments.
What does skewness mean?
Skewness is a measure of the asymmetry of a distribution around its mean. It is positive when the distribution has a tail that extends toward more positive values, and negative when the distribution has a tail that extends toward more negative values.
What kind of arguments does the SKEW function take?
The SKEW function takes numerical, array, and reference arguments. It ignores logical values, text, and empty cells in arguments.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV