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


13f securitiesacceptable skewness and kurtosis valueshow to calculate variance on excelcalculating standard deviation on excelpaulson 13fstdev ifsec 13f filingsprice weighted indexescalculating weighted percentagescontango curveblack scholes theta formulathe black scholes merton modelnotepad stylesexcel formula for squarevix options settlementexcel goal seek macrojpmorganstockvix historical averagehow do you calculate the sample variancerho financeblack scholes methodmacd indicator tutorialhow to find 13f filingsblack scholes standard deviationvolatility excelblack scholes stock option calculatorbearish vs bullishshort euro currency etfhow to calculate standard deviation using calculatorcboe volatility futuresblack sholes calculatortick size futureswhat does overbought meanhow do you calculate the sample variancedaily volatility calculation formulaequation for dividends13f formtrading today black scholes calculatorskewness examplescall option strike priceyahoo share prices historyyahoo finance currency historical dataema calculationlist of section 13f securitiescoefficient of variation calculator exceldeviation from the mean calculatorxiv velocitysharesvolatility calculation excelstock market rsifutures tick valueannualized standard deviation of monthly returnsdefinition of skewness and kurtosiss&p 500 methodologystraddle strategy examplemeaning of rsi in stock marketspy historical returnscalculate variance in excellatest 13f filingshow to write ln in excelcost of ending inventory calculatorspx index bloombergcall options for dummiesdelta hedge examplechicago board options exchange volatility indexinverse etnxiv velocitysharess&p futures bloombergvelocityshares daily inverse vixcalculating skewnessnormdist excel functioncboe vix term structurevix spoteuro usd etfoptions calcyahoo finance quotes csvoptions breakeven calculator