Statistical
KURT Function in Excel
Returns the kurtosis of a data set, measuring the peakedness of the distribution.
Syntax
- =KURT(number1, [number2], ...)
Arguments
- number1 (required): First number or range
- number2 (optional): Additional numbers or ranges
Examples
- =KURT(A1:A100) - Kurtosis - Result: Kurtosis value
KURT for data analysis
- Confirm whether you need entire columns, filtered subsets, or distinct values.
- Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
- Pivot tables complement single-cell statistical formulas for exploration.
Common errors
- Needs at least 4 data points
Use cases
- Distribution shape
- Risk analysis
- Data characterization
Frequently asked questions
- What is kurtosis and what does KURT measure? Kurtosis measures the 'tailedness' of a distribution - how much data is in the tails vs. the center. High kurtosis means heavy tails (more outliers), low kurtosis means light tails. Excel's KURT returns excess kurtosis (normal distribution = 0).
- How do I interpret KURT values? KURT=0: normal distribution tails. KURT>0 (leptokurtic): heavier tails, more outliers than normal. KURT<0 (platykurtic): lighter tails, fewer outliers. In finance, high kurtosis indicates higher risk of extreme events.
- Why is kurtosis important in finance? Financial returns often have high kurtosis ('fat tails'), meaning extreme gains/losses occur more often than normal distribution predicts. This is crucial for risk management - models assuming normal distribution underestimate tail risk.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.