Returns the skewness of a distribution.
Sample Usage
SKEW(A1:A25)
SKEW(A1:A25, B1:B20)
Syntax
SKEW(value1, [value2, ...])
- value1 - The first value or range of the dataset.
- value2, .. - [OPTIONAL] Additional values or ranges to include in the dataset.
Examples
SKEW(A1:A25) returns the skewness of the distribution of the dataset in A1:A25.
Notes
- A minimum of two values must be supplied as value arguments. Else, SKEW will return an error.
- SKEW will ignore any text values found in ranges included in value arguments.
- Positive skewness indicates a longer tail extending in the positive direction, to the right of the mean. Negative skewness indicates a longer tail in the negative direction, to the left.