KURT Function
Returns the kurtosis of a sample — how heavy the tails are.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Overview
Kurtosis compares the tails of your data with a normal bell curve. KURT returns excess kurtosis, so a normal distribution scores about 0.
A positive result means more extreme values than a bell curve (a tall peak with heavy tails — most values close together, plus a few far out). A negative result means flatter data with light tails, such as evenly spread values.
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 — Tails of the sales data
Seven values — close to a bell-curve shape.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Measure | Result |
| 2 | Ana | North | 62000 | Kurtosis | 0.30 |
| 3 | Ben | South | 48500 | Skewness | 0.65 |
| 4 | Cy | North | 50000 | ||
| 5 | Di | East | 71250 | ||
| 6 | Ed | South | 39800 | ||
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
Example 2 — Heavy tails
Six identical values plus two extremes.
Returns 3.5 — far more weight in the tails than a bell curve.
Example 3 — Flat, even spread
Evenly spaced values have no peak at all.
Returns −1.2.
Common mistakes
- #DIV/0! Fewer than four numbers, or all the numbers are the same.
- Small samples. Kurtosis needs plenty of data to be meaningful; a single outlier in a small sample changes it a lot.
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.