The SKEW function in Excel

The function SKEW returns the skewness of a given distribution. The skewness is nothing but the degree of asymmetry of a distribution around its mean.

If the function returns a positive value, it indicates that the distribution has an asymmetrical tail extending toward positive values and if it returns a negative value, it indicates that the given di8stribution has an asymmetrical tail extending toward negative values.

Syntax

The SKEW function has the following syntax and arguments

=SKEW(number1, [ number2], —)

Where

‘number1, number2, — number1 is a required argument and the further numbers are optional. 1 to 255 numbers for which you wish to find the skewness. You can use a reference to an array or a single array instead of numbers separated by commas.

Constraints

If there are less than three data points and if the standard deviation of the data points is zero, the function returns the #DIV/0! Error.

Arguments that are error values or text that cannot be converted into numbers cause errors.
The equation for calculating the skewness is defined as

Example

The examples of the SKEW function are shown in the figure given below

So, this is how you can find the skewness of a distribution using the SKEW function that is present in Excel 2010 Application.

Related reading:  Default Change Network Access Sharing Model for Local Account Users