Excess Kurtosis

You can easily calculate excess kurtosis in Excel using the Descriptive Statistics Calculator.

Excess Kurtosis Definition

Excess kurtosis is kurtosis relative to normal distribution. Kurtosis of normal distribution equals 3. Therefore excess kurtosis equals kurtosis less 3.

Excess Kurtosis Interpretation

Excess kurtosis can reach values from -2 to positive infinite.

Positive excess kurtosis means that the distribution is more peaked (observations close to the mean are more frequent) and has fatter tails (extreme values are more frequent) than normal distribution. Such distribution is calles leptokurtic or leptokurtotic.

Leptokurtic distribution (positive excess kurtosis). The grey line is normal distribution (zero excess kurtosis)

Excess kurtosis of normal distribution is zero. Generally, a distribution that has the same kurtosis as normal distribution (excess kurtosis of zero) is called mesokurtic or mesokurtotic.

Negative excess kurtosis means that the distribution is less peaked and has less frequent extreme values (less fat tails) than normal distribution. Such distribution is called platykurtic or platykurtotic.

Excess Kurtosis Calculation

There is a little difference in calculation of population and sample excess kurtosis. You can see a detailed explanation of the formulas here: Kurtosis Formula.

Population Excess Kurtosis Formula

Excess kurtosis formula

Sample Excess Kurtosis Formula

Sample excess kurtosis formula

Calculating Excess Kurtosis in Excel

In Excel, you can calculate sample excess kurtosis using the KURT function. Population excess kurtosis can be calculated by adjusting the result of KURT (see details how to do it here).

You can easily calculate kurtosis, skewness, standard deviation and other measures using the Descriptive Statistics Excel Calculator.


Related pages


theta call optionannualizewacc preferred stocksample variance formula for grouped datavariance formula excelcalculate standard deviation using excelstock market rsiexcel logarithmspx spyexcel geometric meanjpmorganstockblack scholes modelsstandard deviation example in exceletf swiss francoption trading bookvix s&p500calculating exponential moving averagemacd chartscall option payoff graphhow to calculate variance on a calculatorwhat is skew in statisticsplatykurtic distributioncalculate sharp ratioput option payoff diagramshort sp500 etfmerton black scholeshow do you calculate the sample variancewilliam sharpe nobel prizeyahoo futures indicesmsft stock price historyhedge fund forex strategyvix historical averageoption straddletriple leveraged vix etfgamma black scholessharpe ratio formula excelstdev ifcftc cotwww cboe comexcel formulas for calculationlong straddle strategybutterfly spread calculatorhow to trade using macdaverage deviation definitionhistorical implied volatility chartnotepad default fontoption strategies straddleannualizing standard deviationmsft historical stock pricecv calculation excelvix index yahoostandard deviation calculatorss&p 500 methodologyetf s&p shortsharpe nobel prizevxx financeyahoo finance indexdifference between arbitrage and hedgingexcel formulas statisticsstandard deviation of the sample mean formulahistorical volatility calculatordefinition of sigma in statisticsexcel normdistrsi formula excelblack scholes calculationdelta of an option formulastrike price exercise pricevega greek symbolipath vxxdow jones industrial average weightingsharpe theorysharpe ratio explainedstock price volatility calculatorexcel cash flow diagramblack scholes paper