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.

Kurtosis Calculator Screenshot

Screenshot from Calculator

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).

Screenshot from Charts sheet A 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.

The different ways how to calculate each form of kurtosis in Excel are demonstrated in practice in the second Excel file that comes with the Summary Statistics Calculator (Summary_Statistics_Manual.xlsx, where you can see the exact formulas applied in Excel).

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.


Related pages


rules of multiplying square rootssp500 vixexcel calculate rate of returntrend following trading rulesstrangle tradelist of inverse etfscalculation of skewness and kurtosisstandard deviation calculator percentilejohn c hull solutionsmsft historical pricesintrinsic value of call optionrelative average deviation calculatorpositive kurtosisstandard deviation of monthly returnswhats arithmeticpopulation variance formula exceldefine skewnessoption implied volatility calculatoroptions futures and other derivatives john c hull solution manualannualized return calculation excelcalculating mean and standard deviation in excelatr average true rangeblack scholes thetarsi indicator calculationhow to calculate arithmetic average returngarman kohlhagen modelstandard deviation calculator financebull put spreadexcel probability formulavariance calculation in excel13f sec filingsmacd indicator settingsputs and calls for dummiesoex option chainwhat is the meaning of skewnessformula for sample variance statisticskewness exampledirectional options strategieslong short equity hedge fundsdifference between moving average and exponential smoothingskew excelbloomberg vixfinding the median in excelfutures tick valuehow to calculate variance on exceldjia divisorhow to read macd indicatortheta black scholesstraddle examplehow to calculate thetamomentum calculatoroption pricing model excelhedge fund macro strategyetf short s&poption pricing model black scholesexponential moving average c#vix term structure cboehow to calculate relative strength indexblack scholes examplearithmetic return calculatorvix futures settlementblack scholes formulasstraddle option calculatorsma vs emashort straddle positiongamma function excelbear put spread examplevxx optionrho optionblack scholes option calculatordax market capetf ticker listhow to buy vixcboe volatility index vix