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 relative frequency of extreme values (on either tail of the distribution.

High kurtosis means that extreme values on both the right (high/positive) and the left (low/negative) tail are relatively more frequent (than in a normal distribution with identical mean and standard deviation). It also typically means that the values very close to the mean are relatively more frequent, while the values in between (not too close to the middle, yet not too far on the tails) 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.

Calculating 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.

By remaining on this website or using its content, you confirm that you have read and agree with the Terms of Use Agreement.

We are not liable for any damages resulting from using this website. Any information may be inaccurate or incomplete. See full Limitation of Liability.

Content may include affiliate links, which means we may earn commission if you buy on the linked website. See full Affiliate and Referral Disclosure.

We use cookies and similar technology to improve user experience and analyze traffic. See full Cookie Policy.

See also Privacy Policy on how we collect and handle user data.

© 2024 Macroption