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


trading option greeksgeometric average return formulablack scholes formulasstandard deviation calculator frequencyformula for sample variancestatistics variance calculatorlong straddle option strategymacd histogram crossoveretf ticker listinverse s&p 500 etfvix term structure cboesharpe ratio calculationvolatility in black scholesstraddle options strategydefine squaringexp function excelcolor notepadblack scholes pricergreek vegaskewness calculatorstock option greeksvega black scholescalculate median in exceletn etfdax market capdifferent hedge fund strategieseuro stoxx 50 optionsatr volatilitydax market capema or smasample variance excel formulablack scholes merton calculatorcontango explainedmacro formulascalculating standard deviation on excels&p 500 futures bloombergprotective collar optioncftc commitment of traders reportoption trading bookshedge fund definition examplehow to calculate formulas in excelwww cboe comdow vixoption skew explainedskewness of distributionvix xivxiv vixdefine sharpe ratiohow to find the wacc of a companyvixy etfvix spotstock option intrinsic valueoption trading greek symbolscalculate derivative in excelshort payoffpositive excess kurtosisvolatility avgweighted average cost of capital wacc formulasample variance formula exampleweighted average inventory methodsoros fund management portfoliocharacteristics of a hedge fundpayoff diagrams for call and put optionshow to use natural log in excelat the money straddledelta hedging put optionaverage cost method formulacalculating sample varianceoptions greeks calculatorvolatility index formulacontract multiplier futuresformula standard deviation excelblackscholes calculatorsimple spreadsheet formulasstandard dev calcvariance formula ungrouped datayahoo finance download csvwhat to invest in besides stocksdifference between arbitrage and hedgingwhat does macd mean