Kurtosis Calculator

Kurtosis Excel Calculator

This Excel spreadsheet calculates kurtosis, skewness, standard deviation, and other summary statistics for a data set you enter. Simply copy-paste your data (order doesn't matter) into the column marked in the file, choose population or sample, and see the result.

Get Kurtosis Calculator here.

Kurtosis Calculator Screenshot

Summary Statistics Calculator - Screenshot from Data sheet

The Calculator also contains several charts where you can evaluate kurtosis and the other measures visually and you can compare your data to normal distribution (which has kurtosis of 3 = zero excess kurtosis).

Summary Statistics Calculator - Screenshot from Charts sheet Chart comparing your data to normal distribution - this data is leptokurtic (high kurtosis) Frequency / Normal Distribution Frequency Ratio Chart

Calculating Kurtosis in Excel

There is a built in function for calculating kurtosis in Excel: KURT. This function actually calculates sample excess kurtosis. There are no built-in functions for calculating the other forms of kurtosis (population kurtosis, sample kurtosis, population excess kurtosis), but you can calculate them by adjusting the result of KURT manually - see detailed instructions here: Calculating Kurtosis in Excel. Alternatively, you can calculate them directly using the formulas below.

How to Calculate Kurtosis Manually

Calculating Population Kurtosis

Population kurtosis formula

Calculating Population Excess Kurtosis

Population excess kurtosis formula

Calculating Sample Kurtosis

Sample kurtosis formula

Calculating Sample Excess Kurtosis

Sample excess kurtosis formula

Detailed explanation and derivation of the formulas is available here: Kurtosis Formula.

Download the Kurtosis Calculator

Here you can get the Kurtosis Calculator.