The following article introduces you to SKEW function - one of the functions in the statistical function group is very popular in Excel.
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!