KURT

Statistical Functions

(4.7/5)

Returns the kurtosis of a data set. Kurtosis measures the tail weight and peak height of a distribution relative to a normal distribution. Positive kurtosis indicates heavy tails and/or sharp peak; negative kurtosis indicates light tails and/or flat peak. Zero indicates normal-like distribution. Essential for understanding distribution shape, detecting outliers, and statistical analysis.

Interactive Formula Tester

Numbers:

Formula:

=KURT("10, 20, 30, 40, 50, 60")

Complete Theory & Understanding

Master the fundamentals of Excel KURT function

Core Concept

The KURT function returns the kurtosis of a data set. Kurtosis measures the tail weight and peak height of a distribution relative to a normal distribution. Positive kurtosis (KURT > 0) indicates heavy tails (more outliers/extreme values) and/or a sharp peak - distribution is more peaked than normal. Negative kurtosis (KURT < 0) indicates light tails (fewer outliers) and/or a flat peak - distribution is flatter than normal. Zero kurtosis (KURT = 0) indicates normal-like distribution. Requires at least 4 values. Essential for understanding distribution shape, detecting outliers, statistical analysis, and determining distribution characteristics.

Why Use KURT?

Analyze distribution shape
Detect heavy-tailed distributions
Kurtosis in statistics
Analyze process distribution

Key Characteristics

Measures Tail Weight

Weight of tails relative to normal

Positive = heavy tails, Negative = light tails

Measures Peak Height

Peak sharpness relative to normal

Positive = sharp peak, Negative = flat peak

Minimum 4 Values

Requires at least 4 numbers

KURT needs distribution to measure

Distribution Shape

Describes peak and tail behavior

0 = normal-like, |KURT| > 2 = significantly different

Function Anatomy

=KURT(parameters...)

Required

Parameters:

Function-specific parameters

Returns

Return Value:

Function-specific return type

Primary Use Cases

Distribution Analysis

Analyze distribution shape

Outlier Detection

Detect heavy-tailed distributions

Statistical Analysis

Kurtosis in statistics

Quality Control

Analyze process distribution

Theory Summary

Precise

Exact matching required

Position-Based

Returns numeric position

Error-Safe

Handles missing text gracefully

Syntax & Parameters

=KURT(number1, number2)

Required

number1:

First number, cell reference, or range.

Optional

number2:

Additional numbers, cell references, or ranges (up to 255 arguments).

Returns

Return Value:

The kurtosis of the data set

Description: Returns the kurtosis of a data set

Interactive Examples

Basic KURT

Calculate kurtosis

Input Text:

"Normal-like data"

Formula:

=KURT(data_range)

Result:

≈ 0

Returns approximately 0 for normal-like distributions. KURT measures tail weight and peak: positive = heavy tails/sharp peak, negative = light tails/flat peak.

VBA Implementation & Automation

Basic KURT in VBA

Use KURT function in VBA

' Basic KURT in VBA
Range("C1").Value = Application.WorksheetFunction.Kurt(Range("A1:A10"))
' Returns: Kurtosis value

' Calculate kurtosis
Sub CalculateKurtosis()
    Dim kurtValue As Double
    kurtValue = Application.WorksheetFunction.Kurt(Range("A1:A10"))
    Range("B1").Value = kurtValue
End Sub

' Interpret kurtosis
Sub InterpretKurtosis()
    Dim kurtValue As Double
    Dim interpretation As String
    kurtValue = Application.WorksheetFunction.Kurt(Range("A1:A10"))
    
    If kurtValue > 2 Then
        interpretation = "Heavy tails / Sharp peak"
    ElseIf kurtValue < -2 Then
        interpretation = "Light tails / Flat peak"
    Else
        interpretation = "Normal-like"
    End If
    
    Range("B1").Value = "KURT: " & kurtValue
    Range("B2").Value = interpretation
End Sub

' Compare with SKEW
Sub CompareKurtSkew()
    Dim kurtValue As Double
    Dim skewValue As Double
    kurtValue = Application.WorksheetFunction.Kurt(Range("A1:A10"))
    skewValue = Application.WorksheetFunction.Skew(Range("A1:A10"))
    Range("B1").Value = "Kurtosis: " & kurtValue
    Range("B2").Value = "Skewness: " & skewValue
    Range("B3").Value = "Shape: " & IIf(Abs(kurtValue) > 2, "Significantly different from normal", "Normal-like")
End Sub

' Distribution shape analysis
Sub DistributionShapeAnalysis()
    Dim kurtValue As Double
    Dim skewValue As Double
    Dim meanValue As Double
    Dim stdevValue As Double
    kurtValue = Application.WorksheetFunction.Kurt(Range("A1:A10"))
    skewValue = Application.WorksheetFunction.Skew(Range("A1:A10"))
    meanValue = Application.WorksheetFunction.Average(Range("A1:A10"))
    stdevValue = Application.WorksheetFunction.StDev(Range("A1:A10"))
    Range("B1").Value = "Mean: " & meanValue
    Range("B2").Value = "STDEV: " & stdevValue
    Range("B3").Value = "Skewness: " & skewValue
    Range("B4").Value = "Kurtosis: " & kurtValue
End Sub

Business Applications

Distribution Analysis

Analyze distribution shape

=KURT(data_distribution)

Outlier Detection

Detect heavy-tailed distributions

=KURT(data_with_outliers)

Statistical Analysis

Kurtosis in statistical analysis

=KURT(sample_data)

Quality Control

Analyze process distribution

=KURT(process_data)

Common Issues & Solutions

#DIV/0! Error

KURT returns #DIV/0! with less than 4 values

=IF(COUNT(A1:A10)>=4, KURT(A1:A10), "Need 4+ values")

Solution: KURT requires at least 4 numeric values. With 0-3 values, it cannot calculate kurtosis. Ensure you have at least 4 numeric values in the range.

Understanding Values

Difficulty interpreting KURT

|KURT| > 2 = significantly different from normal

Solution: Interpretation: |KURT| > 2 = significantly different from normal. KURT > 0 = heavy tails/sharp peak, KURT < 0 = light tails/flat peak, KURT ≈ 0 = normal-like.

KURT vs SKEW

Uncertainty about difference

KURT = tail weight/peak, SKEW = asymmetry

Solution: KURT measures tail weight and peak height. SKEW measures asymmetry (tail direction). Both describe distribution shape but measure different aspects.

Zero Kurtosis

KURT returns 0

KURT = 0 means normal-like distribution

Solution: KURT = 0 indicates normal-like distribution (normal kurtosis). This is expected for normal distributions. It means tail weight and peak are similar to normal.