FormulaCraft

KURT

KURT quantifies whether a distribution has heavier or lighter tails than a normal (bell curve) distribution: positive kurtosis (leptokurtic) indicates more extreme outliers, while negative kurtosis (platykurtic) indicates fewer. It is used in risk management and data quality assessments to detect fat-tailed behavior.

Excel
=KURT(A2:A5)
Google Sheets
=KURT(A2:A5)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Assemble at least four numeric values in a range; KURT requires a minimum of 4 data points.
  2. 2Enter =KURT(range) to obtain the excess kurtosis (normalized to 0 for a normal distribution).
  3. 3Values above 0 suggest heavier tails with more outliers; values below 0 suggest lighter tails.

Need a version for your data?

Try: “Determine whether our daily stock return distribution has heavier tails than a normal distribution

Related

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: