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.

By remaining on this website or using its content, you confirm that you have read and agree with the Terms of Use Agreement.

We are not liable for any damages resulting from using this website. Any information may be inaccurate or incomplete. See full Limitation of Liability.

Content may include affiliate links, which means we may earn commission if you buy on the linked website. See full Affiliate and Referral Disclosure.

We use cookies and similar technology to improve user experience and analyze traffic. See full Cookie Policy.

See also Privacy Policy on how we collect and handle user data.

© 2024 Macroption