Kurtosis in Excel (KURT)

KURT Excel Function

In Excel, kurtosis can be comfortably calculated using the KURT Excel function. The only argument needed for KURT function is the range of cells containing the data.

For example the function:

KURT(C5:C104)

will calculate kurtosis for the set of values contained in cells C5 through C104.

Which Kind of Kurtosis Excel Actually Calculates

The KURT Excel function calculates sample excess kurtosis – it’s this formula:

Sample excess kurtosis formula

If you want to use Excel for calculating one of the other kinds of kurtosis – sample kurtosis, population kurtosis, or population excess kurtosis, there is no built-in Excel function you can simply use. You can either calculate them by adjusting from the KURT Excel function, or calculate them directly from your input data. See the rest of this page for details.

For differences in the four kinds of kurtosis and detailed explanation of the formulas, see kurtosis formula.

Calculating Population Excess Kurtosis in Excel

You can calculate population excess kurtosis directly using this formula:

Population excess kurtosis formula

One disadvantage of this calculation is that you need to calculate the individual deviations from the mean, squared and raised to the power of 4, in separate cells. If you are working with large data sets, it will make the Excel file very big and possibly slow to calculate.

Therefore it is often better to use the KURT Excel function and adjust the result from sample to population. The adjustment is as follows:

((KURT(Data!$B$16:$B$10015)*($G$5-2)*($G$5-3)/($G$5-1))-6)/($G$5+1)

This is the function I use in the Descriptive Statistics Calculator. The first part – KURT(Data!$B$16:$B$10015) – is the built-in Excel KURT function for sample excess kurtosis of cells B16 through B10015, and the rest is the adjustment from sample to population excess kurtosis, where cell G5 calculates population size:

G5 = COUNT(Data!$B$16:$B$10015)

The whole formula is:

Population Excess Kurtosis = ( ( Sample Excess Kurtosis x (N-2) x (N-3) / (N-1) ) – 6 ) / (N+1)

Where N = population size (number of values)

As you can see, you don’t need to calculate the deviations from the mean in separate cells.

Calculating Population Kurtosis in Excel

If you want to calculate population (non-excess) kurtosis in Excel, you simply take population excess kurtosis that we’ve just calculated above and add 3, because:

Population Excess Kurtosis = Population Kurtosis – 3

Calculating Sample Kurtosis in Excel

Contrary to popular belief, sample excess kurtosis does not equal sample kurtosis less 3 (as it is with population kurtosis), but you need to adjust the minus 3 for the data set being a sample.

Sample excess kurtosis is:

Sample excess kurtosis formula

Sample kurtosis is:

Sample kurtosis formula

Therefore you can calculate sample kurtosis from sample excess kurtosis (which is the direct result of the built-in KURT Excel function) as follows:

Sample Kurtosis = Sample Excess Kurtosis + ( 3 (N-1)2 / ( (N-2) x (N-3) ) )

Of course, if you don’t mind a large Excel file you can also calculate sample kurtosis directly using the sample kurtosis formula above.

You can see how kurtosis Excel calculation works in practice in the Descriptive Statistics Calculator.


Related pages


variance of grouped data formulaciti reverse splithow to calculate sigma in exceletf correlationbearish vs bullishsec filings wikicboe historycost of common equity capital calculatorspx chartscreate formulas in excelnormal kurtosiskurtosis and skewness normal distributionoption greeks formulaexcel calculation formulaspx spyblack scholes exampleleptokurtic graphdow jones index calculation methodologyhow to calculate skewnesssoros hedge fund holdingsultra short sp500intrinsic value vs market valuesec 13f searchcalculating probability in excelhow to do goal seek in excel 2010options futures and other derivatives john c hull solution manualcall option payoff diagramlatest 13d filingsultra short s&pinterpreting kurtosisvolatility index formulablack sholeblack scholes dividend paying stockcboe s&p 500how to write pi in excelmacd trading strategiescalculating sample size in excelfutures roll datescalculate delta of optionimplied volatility black scholeshow to trade vix optionsoptions straddle calculatoroption payoff calculatorunbiased estimate of the population varianceexcel calculate standard deviationvariance mathsexcel natural logarithmprofit & loss formulasblack scholes merton calculatorblack scholes delta calculatorwhat is percent deviationvolatility calculation excelblack scholes greeksoption deltasmeasure of skewnessrsi explainedsharpe formulaexcel macro averageiron butterfly optionarithmetic mean formulasblack scholes merton option pricing modelrsi overbought oversoldskewness calculator onlinecall options for dummiesimplied volatility formulastandard deviation and variance calculatorvariance formula for grouped dataweighted average market caphow to compute in excelnegative and positive numbers calculatorinterpreting variance and standard deviationuvyxcalculate vegasmoothed rsi indicatorhow to calculate sharpe ratioexample of stock indexpayoff diagrams for call and put optionsrsi meanskurtosis and skewness formulacalculating averages on excelmacd histogram crossoverticker vxxeuro currency etf