SKEW Function

Returns the skewness of a sample — how lopsided the data is.

Category

Statistical

Available in

All versions, Microsoft 365

Returns

A number

Want to practice SKEW in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

Skewness describes the shape of the data. 0 means balanced on both sides of the average. A positive result means a long tail of high values (most values low, a few very high — like incomes); a negative result means a long tail of low values.

SKEW is the sample version. As a rough guide, results between −0.5 and 0.5 are fairly symmetrical.

Syntax

=SKEW(number1, [number2], …)

Arguments

ArgumentRequired?What it does
number1YesA number, cell or range.
number2, …NoUp to 254 more numbers, cells or ranges.

Examples

Example 1 — Are sales lopsided?

Di's 71,250 stretches the top end.

E2fx=SKEW(C2:C8)
ABCDE
1RepRegionSalesMeasureResult
2AnaNorth62000Skewness0.65
3BenSouth48500Average53635.71
4CyNorth50000Median50000
5DiEast71250
6EdSouth39800
7FayNorth55400
8GusEast48500
=SKEW(C2:C8) Explain

Positive skew — and the average sits above the median, as it usually does when the tail is on the high side.

Example 2 — Perfectly balanced

Values spaced evenly around the middle have no skew.

=SKEW(1,2,3) Explain

Returns 0.

Common mistakes

  • #DIV/0! Fewer than three numbers, or all the numbers are the same (no spread).
  • Small samples. With only a handful of values, skewness jumps around a lot. Treat it as a hint, not a verdict.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.