SKEW
Formulas / SKEWCalculate 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?
What does skewness mean?
What kind of arguments does the SKEW function take?
