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


black scholes equation explainedusing natural log in excelequation for skewnessarbitrage hedge fundsstraddle payoff diagrampricing excel templatepopulation standard deviation calculatoradaptive moving average formulamacd indicator formulahow to buy vixgeometric rate of return calculatorusing natural log in excelblack scholes simplifiedmeasure of kurtosisblack-scholes valuation modelstd dev calcvix etf 3xannualizingdebit call spreadgeometric mean negative numberscalculate standard deviation using excelnotepad with colorshort etf s&poptions profit and loss calculatorspreadsheets formulasvix etfsincentric valueoption straddle strategiescalculate standard deviation excelformula for standard deviation on excelaapl historystandard deviation on financial calculatorthe black scholes merton modelfree float market capitalisationblack scholes theta formulameasure of kurtosissum of squared deviations formulaoptions expiration calendardays calculator formula excelsimple average method of inventory valuationformula for kurtosis in statisticsform 13fmomentum formulasvariance on calculatorcalculate vegadividing big numbers without a calculatorhow do you buy the vixblack scholes equationshistorical vix chartcall option thetaproshares inverse etfhow to annualize daily returnsexcel macro averagesum of squares formula statisticsema rsihow to create excel formulasmeaning of hedge fundsrsi explainedmsft excelskewness meanssample kurtosisnegative kurtosishow to interpret kurtosisexcel normdistpayoff of call optionmomentum calculatorwhat is skewness and kurtosis in statisticsskewness and kurtosis examplesmsft historical pricessell put option graphcalculating kurtosiskurtosis distributionweighted average cost of capital formula exampleln x excelweighted average cost of capital calculator