SKEW Function
Returns the skewness of a sample — how lopsided the data is.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number1 | Yes | A number, cell or range. |
| number2, … | No | Up to 254 more numbers, cells or ranges. |
Examples
Example 1 — Are sales lopsided?
Di's 71,250 stretches the top end.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Measure | Result |
| 2 | Ana | North | 62000 | Skewness | 0.65 |
| 3 | Ben | South | 48500 | Average | 53635.71 |
| 4 | Cy | North | 50000 | Median | 50000 |
| 5 | Di | East | 71250 | ||
| 6 | Ed | South | 39800 | ||
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
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.
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

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.