KURT Function

Returns the kurtosis of a sample — how heavy the tails are.

Category

Statistical

Available in

All versions, Microsoft 365

Returns

A number

Want to practice KURT 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

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

=KURT(number1, [number2], …)

Arguments

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

Examples

Example 1 — Tails of the sales data

Seven values — close to a bell-curve shape.

E2fx=KURT(C2:C8)
ABCDE
1RepRegionSalesMeasureResult
2AnaNorth62000Kurtosis0.30
3BenSouth48500Skewness0.65
4CyNorth50000
5DiEast71250
6EdSouth39800
7FayNorth55400
8GusEast48500
=KURT(C2:C8) Explain

Example 2 — Heavy tails

Six identical values plus two extremes.

=KURT(10,10,10,10,10,10,30,-10) Explain

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.

=KURT(1,2,3,4,5,6,7,8) Explain

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

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.