# Documentation/Calc Functions/SKEW

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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.

## Examples:

Formula | Description | Returns |
---|---|---|

=SKEW(3;4;5;6;2;3;1) | The function calculates the skewness of the data | 0.168964169587949 |

=SKEW(A1:A5) where A1:A5 contains 1,2,3,4,5 | The function calculates the skewness of the data passed as a cell range. | 0 |

=SKEW(3;4) | The function will return a division error since less than 3 values are specified. | #DIV/0! |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

SKEW