EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Kurtosis Formula
Secondary Sidebar
Finance Blog
  • Accounting Fundamentals Resources (720+)
  • Asset Management Tutorial (200+)
  • Banking (44+)
  • Corporate Finance Resources (374+)
  • Credit Research Fundamentals (6+)
  • Economics (104+)
  • Finance Formula (384+)
  • Financial Modeling in Excel (16+)
  • Investment Banking Resources (142+)
  • Investment Banking Careers (29+)
  • Trading for dummies (69+)
  • valuation basics (26+)
  • Insurance Resources (15+)
  • Top Finance Books (33+)
Finance Blog Courses
  • Investment Banking Course
  • Investment Banking Online Course
  • Financial Modeling Certification

Kurtosis Formula

By Madhuri ThakurMadhuri Thakur

Kurtosis Formula

Kurtosis Formula (Table of Contents)

  • Formula
  • Examples

What is the Kurtosis Formula?

The term “Kurtosis” refers to the statistical measure that describes the shape of either tail of a distribution, i.e. whether the distribution is heavy-tailed (presence of outliers) or light-tailed (paucity of outliers) compared to a normal distribution. In other words, it indicates whether the tail of distribution extends beyond the ±3 standard deviation of the mean or not.

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

There are three types of kurtosis that can be exhibited by any distribution:

  1. Leptokurtic or heavy-tailed distribution (kurtosis more than normal distribution)
  2. Mesokurtic (kurtosis same as the normal distribution)
  3. Platykurtic or short-tailed distribution (kurtosis less than normal distribution)

The formula for kurtosis is expressed as the ratio of the fourth moment and variance (s2) squared or squared the second moment of the distribution. Mathematically, it is represented as,

Kurtosis = n * Σni(Yi – Ȳ)4 / (Σni(Yi – Ȳ)2)2

Where

  • Yi: ith Variable of the Distribution
  • Ȳ: Mean of the Distribution
  • n: No. of Variables in the Distribution

Example of Kurtosis Formula (With Excel Template)

Let’s take an example to understand the calculation of Kurtosis in a better manner.

You can download this Kurtosis Formula Excel Template here – Kurtosis Formula Excel Template

Kurtosis Formula – Example #1

Let us take the example of the following data distribution to illustrate the computation of kurtosis of a leptokurtic distribution: 26, 12, 16, 56, 112, 24.

Example1

Solution:

Mean is calculated as,

Kurtosis Formula - 1.3

  • Mean Ȳ = (26 + 12 + 16 + 56 + 112 + 24) / 6
  • Mean Ȳ = 41

Standard Deviation is calculated as

Kurtosis Formula - 1.4

Deviation2 and Deviation4 is calculated as

Kurtosis Formula - 1.5

Second Moment is calculated using the formula given below

Second Moment = Σni(Yi – Ȳ)2 / n

Second Moment

  • Second Moment = [(26 – 41)2 + (12 – 41)2 + (16 – 41)2 + (56 – 41)2 + (112 – 41)2 + (24 – 41)2] / 6
  • Second Moment = 1207.67

Fourth Moment is calculated using the formula given below

Fourth Moment = Σni(Yi – Ȳ)4 / n

Fourth Moment

  • Fourth Moment = [(26 – 41)4 + (12 – 41)4 + (16 – 41)4 + (56 – 41)4 + (112 – 41)4 + (24 – 41)4] / 6
  • Fourth Moment = 4449059.67

Kurtosis is calculated using the formula given below

Kurtosis = Fourth Moment / (Second Moment)2

Kurtosis Formula - 1.8

  • Kurtosis = 4449059.667 / (1207.667)2
  • Kurtosis = 3.05

Since the kurtosis of the distribution is more than 3, it means it is a leptokurtic distribution.

Kurtosis Formula – Example #2

Let us take the example of the following data distribution to illustrate the computation of kurtosis of a platykurtic distribution: 42, 20, 38, 78, 54, 26

Example - 2

Solution:

Mean is calculated as

Mean

  • Mean Ȳ = (42 + 20 + 38 + 78 + 54 + 26) / 6
  • Mean Ȳ = 43

Deviation, Deviation2 and Deviation4 is calculated as same as shown in the example1.

Kurtosis Formula - 2.2

The second Moment is calculated using the formula given below

Second Moment = Σni(Yi – Ȳ)2 / n

Kurtosis Formula - 2.5

  • Second Moment = [(42 – 43)2 + (20 – 43)2 + (38 – 43)2 + (78 – 43)2 + (54 – 43)2 + (26 – 43)2] / 6
  • Second Moment = 365

Fourth Moment is calculated using the formula given below

Fourth Moment = Σni(Yi – Ȳ)4 / n

Kurtosis Formula - 2.6

  • Fourth Moment = [(42 – 43)4 + (20 – 43)4 + (38 – 43)4 + (78 – 43)4 + (54 – 43)4 + (26 – 43)4] / 6
  • Fourth Moment = 313209

Kurtosis is calculated using the formula given below

Kurtosis = Fourth Moment / Second Moment2

Kurtosis Formula - 2.7

  • Kurtosis = 313209 / (365)2
  • Kurtosis = 2.35

Since the kurtosis of the distribution is less than 3, it means it is a platykurtic distribution.

Explanation

The formula for Kurtosis can be calculated by using the following steps:

Step 1: Firstly, after forming the data distribution, determine the number of variables in the distribution which is denoted by ‘n’.

Step 2: Next, compute the mean of the distribution, which is the aggregate of all the variables (Yi) in the distribution divided by the number of variables of the distribution (n). It is denoted by Ȳ.

Ȳ = ΣnYi / n

Step 3: Next, determine the fourth moment of the distribution by summing up the fourth power of deviation between each variable and mean (step 2) which is then divided by the number of variables in the distribution (step 1).

Fourth Moment = Σni(Yi – Ȳ)4 / n

Step 4: Next, determine the variance (s2) or second moment of the distribution by summing up the square of deviation between each variable and mean (step 2) which is then divided by the number of variables in the distribution (step 1).

s2 = Σni(Yi – Ȳ)2 / n

Step 5: Finally, the formula for kurtosis can be derived by dividing the fourth moment (step 3) by the squared second moment of the distribution (step 4) as shown below.

Kurtosis = n * Σni(Yi – Ȳ)4 / (Σni(Yi – Ȳ)2)2

Relevance and Use of Kurtosis Formula

For a data analyst or statistician, the concept of kurtosis is very important as it indicates how are the outliers distributed across the distribution in comparison to a normal distribution. At times, relative kurtosis of distribution is represented in terms of excess kurtosis wherein it is calculated by deducting 3 from the kurtosis, i.e. (kurtosis – 3)

  • If Positive, Then It Is a Leptokurtic Distribution
  • If Zero, Then It Is a Mesokurtic Distribution
  • If Negative, Then It Is a Platykurtic Distribution

The concept of kurtosis finds serious application in the field of risk management and portfolio management where it indicates if there is any chance of extreme values or returns (positive and negative) beyond the ±3 standard deviation of the mean (99.5% confidence interval). Please note that an investor is more comfortable with a platykurtic distribution of return as it indicates stable returns and lower risk of sudden shock of outliers, while leptokurtic distribution means chances of higher return but with higher risk.

Recommended Articles

This is a guide to Kurtosis Formula. Here we discuss how to calculate the Kurtosis Formula along with practical examples. We also provide a downloadable excel template. You may also look at the following articles to learn more –

  1. Interpolation Formula
  2. Convexity Formula
  3. Tax Multiplier Formula
  4. Efficiency Formula
Popular Course in this category
Investment Banking Training
  124 Online Courses |  25 Hands-on Projects |   600+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Financial Modeling Training4.9
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download Kurtosis Formula Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Kurtosis Formula Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more