How to Use the SKEW Function in Excel

This guide explains how to use SKEW Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function returns the deviation of the distribution - the deviation represents the asymmetry of the distribution around its axis.

- Negative deviations: The distribution with the asymmetric side extends more to the negative value.

- Positive deviations: The distribution with the asymmetric side extends more to the positive value.

Syntax: SKEW (number1, [number2]. )

Inside:

- number1, [number2]. ) : The values you want to calculate the deviation, where number1 is the required value, the next values are optional and contain up to 255 number parameters .

Attention:

- The value of the argument must be a number, name, array or reference containing numbers.

- Logical values and text number representations when typing directly into the argument list -> still count.

- Arguments that are text or error values cannot be converted to a numeric type -> cause the function to cause an error .

- If the argument is a reference array containing text values or logic -> these values are ignored, but the value 0 is still counted.

- If there are fewer than 3 data points or the standard deviation is 0 -> the function returns the # DIV / 0 error value .

- The deviation equation is determined by the formula:

[frac {n} {{left ({n - 1} right) left ({n - 2} right)}} {sum {left ({frac {{{x_i} - bar x}} {s}} right) } ^ 3}]

For example:

Calculate the deviation of the distribution of values in the following data table:

- Calculate the deviation of the distribution of number values . In a cell to calculate enter the formula : = SKEW (D6: D10)

- Press Enter -> deviation of distribution of number values is:

- Calculate the deviation of the distribution of the values of number and 58. In the cell to calculate enter the formula : = SKEW (D6: D10,58)

- Press Enter -> deviation of the distribution of the numbers number and 58 are:

Above are instructions and some specific examples when using SKEW function in Excel.

Good luck!