ReferenceFunctionsStatistics Functions
SKEW
Returns the sample skewness of a numeric distribution.
Summary
SKEW quantifies asymmetry: positive values indicate a longer right tail, negative values a
longer left tail.
Remarks
- Requires at least three numeric values.
- Returns
#DIV/0!when there are fewer than three numbers or zero sample standard deviation. - Non-numeric values in ranges are ignored by statistical-collection rules.
- Uses the Excel-style sample skewness correction factor.
Examples
Symmetric sample
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0
Right-skewed sample
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
1.9683567600862015
Related functions
Runtime metadata
Category
Statistics
Signature
SKEW(arg1…: Number (Range))This function accepts a repeating argument pattern (min args: 1).
Arity
min 1, max variadic
Arguments
arg1Number · Range · coercion NumberLenientText
Caps
PUREREDUCTIONNUMERIC_ONLY
Source