Coefficient of Kurtosis

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

Coefficient of Kurtosis

The coefficient of kurtosis, or simply kurtosis, measures the peakedness of a distribution. High kurtosis means that values close to the mean are relatively more frequent and extreme values (very far from the mean) are also relatively more frequent. The values in between are relatively less frequent. If you plot a frequency histogram or another chart showing frequency of such distribution, it would have a sharp peak in the middle and fat tails.

A distribution with high coefficient of kurtosis

Conversely, low coefficient of kurtosis means that a distribution is less peaked and has thinner tails.

Coefficient of Kurtosis Formula

Coefficient of Kurtosis for a Population

Population kurtosis formula

Coefficient of Kurtosis for a Sample

Sample kurtosis formula
You can see a more detailed explanation of the formulas and their underlying logic here: Kurtosis Formula.

Excess Kurtosis

Kurtosis is often measured and quoted in the form of excess kurtosis, which is kurtosis relative to normal distribution. The coefficient of kurtosis for normal distribution is 3, therefore excess kurtosis equals coefficient of kurtosis less 3.

Calculate Kurtosis in Excel

Here you can see more information about calculating population and sample coefficient of kurtosis and excess kurtosis in Excel.

Here you can get an Excel Calculator of kurtosis, skewness, and other summary statistics.


Related pages


downside risk calculationbull call spread payoff diagramsimple spreadsheet formulasvix trading hourswhat is a straddle positionwww proshares comvxx ipathwhat is negative three squaredvar calculation excelfinance.yahoo.com historical pricesyahoo finance sp500how to solve kurtosiswhat is the difference between futures and forwardshow is implied volatility calculatedblack-scholes-merton option pricing modelpearson coefficient excelkurtosis defines&p inverse etfderivation of black scholes modelaverage deviation calculatormsft share price historyexcel formulas explainedmeasure of skewnesshow to calculate formula in excelsum of squared deviations formulaput option profit calculatorkurtosis calculationuvxy shortoptions expiration calendarvega calculatorcost of preferred equity formulaadvantages of mean median modecalculate standard deviation excelspx s&p 500population calculator statisticscboe wikiwhat does the word volatility meaninverse sp500 etfvix futures quotesdetermining skewnessprice variance calculatorexcel geometric meanhow to calculate rhocalculating volatility of a stockchange notepad background colorcftc govoptions futures and other derivatives solution manualstrike price exercise pricevix index chartsharpe ratio rangecalculating sample size in exceltick size futuresformula to calculate average in excelblack scholes theoryoption greeks explainedipath s&p 500 vix short-term futures etnsample mean standard deviation calculatorcalculating standard deviation on excelfifo and weighted averagevix futures volumeintrinsic value formula excelblack scholes merton calculatorblack scholes merton option pricing modelblack scholes implied volatility formularelative deviation calculatornegative sharpe ratio interpretationsample variance formula examplemacd trading signalsoption position simulatoripath barclaysblack scholes volatility calculatorcalculating sharpe ratio in excelvix trading hoursoption calculator profitexamples of skewness and kurtosisstd deviation calculationcitibank reverse splitsquared deviation formulaspx cboefinding variance on exceldow jones highest ever closings&p 500 vix short-term futuresequally weighted portfoliovariance equals standard deviation