Documentation/Calc Functions/SKEW

Function name:
SKEW

Category:
Statistical Analysis

Summary:
Calculates the skewness of a distribution using a sample set of numbers. Skewness is a measure of the asymmetry of a distribution about its mean.

Syntax:
SKEW(Number 1[; Number 2[; ...[; Number 255]]])

Returns:
Returns a real number which is the skewness of a distribution estimated using the specified sample of numbers.

Arguments:
Number 1, Number 2, ..., Number 255 are numbers, references to cells or to cell ranges of numbers.


 * The parameters should specify at least three values. If there are less than three values, then the function will return a division (#DIV/0!) error.
 * If any of the arguments contain text value either being passed directly then the function returns a name (#NAME?) error and if with double quotes then the function returns an error value (Err:504).
 * If a cell contains text, error value, or empty cells, then the function ignores these values. However, for logical values TRUE is considered as 1 and FALSE as 0.
 * If a cell contains 0 then the function includes it.

Additional details:

 * The formula for SKEW is:

where N is the count of data points, x̄ is the expectation value (mean of the specified set of numbers) and s is the standard deviation estimate (standard deviation of the specified set of numbers).
 * For more details on skewness, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/SKEWP SKEWP]

ODF standard:
Section 6.18.67, part 2

Equivalent Excel functions:
SKEW