WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Normal Distribution Formula

Normal Distribution Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Normal Distribution Formula

Normal distribution is a distribution that is symmetric i.e. positive values and the negative values of the distribution can be divided into equal halves and therefore, mean, median and mode will be equal. It has two tails one is known as the right tail and the other one is known as the left tail.

The formula for the calculation can be represented as

X ~ N (µ, α)

Where

  • N= no of observations
  • µ= mean of the observations
  • α= standard deviation

In most of the cases, the observations do not reveal much in its raw form. So it is essential to standardize the observations to be able to compare that. It is done with the help of the z-score formula. It is required to calculate the Z-score for an observation.

The equation for Z Score Calculation for the normal distribution is represented as follows,

Z=(X- µ)/ α

Normal Distribution Formula

Where

  • Z= Z-score of the observations
  • µ= mean of the observations
  • α= standard deviation

Explanation

A distribution is normal when it follows a bell curve. It is known as the bell curve as it takes the shape of the bell. One of the most important characteristics of a normal curve is, it is symmetric, which means the positive values and the negative values of the distribution can be divided into equal halves. Another essential characteristic of the variable being is that the observations will be within 1 standard deviation of the mean 90% of the time. The observations will be two standard deviations from the mean 95% of the time, and it will be within three standard deviations from the mean 99% of the time.

Examples

You can download this Normal Distribution Formula Excel Template here – Normal Distribution Formula Excel Template

Example #1

The mean of the weights of a class of students is 65kg, and the standard of the weight is .5 kg. If we assume that the distribution of the return is normal, then let us interpret for the weight of the students in the class.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

When a distribution is normal, then 68% of it lies within 1 standard deviation, 95% lies within 2 standard deviations, and 99% lies with 3 standard deviations.

Given,

  • The mean return for the weight will be 65 kgs
  • The standard deviation will be 3.5 kgs

normal distribution formula example 1

So, 68% of the time, the value of the distribution will be in the range as below,

normal distribution formula example 1.1jpg

  • Upper Range = 65+3.5= 68.5
  • Lower Range = 65-3.5= 61.5
  • Each tail will (68%/2) = 34%

Example #2

Let’s continue with the same example. The mean of the weights of a class of students is 65kg, and the standard of the weight is 3.5 kg. If we assume that the distribution of the return is normal, then let us interpret it for the weight of the students in the class.

Given,

  • The mean return for the weight will be 65 kgs
  • The standard deviation will be 3.5 kgs

normal distribution formula example 2jpg

So, 95% of the time, the value of the distribution will be in the range as below,

 example 2.1jpg

  • Upper Range =65+(3.5*2)= 72
  • Lower Range = 65-(3.5*2)= 58
  • Each tail will (95%/2) = 47.5%

Example #3

Let’s continue with the same example. The mean of the weights of a class of students is 65kg, and the standard of the weight is 3.5 kg. If we assume that the distribution of the return is normal, then let us interpret it for the weight of the students in the class.

Given,

  • The mean return for the weight will be 65 kgs
  • The standard deviation will be 3.5 kgs

 example 3pg

normal distribution equation example 3.1pg

So, 99% of the time, the value of the distribution will be in the range as below,

  • Upper Range = 65+(3.5*3)= 75.5
  • Lower Range = 65-(3.5*3)= 54.5
  • Each tail will (99%/2) = 49.5%

Relevance and Use

The normal distribution is an essential statistical concept as most of the random variables in finance follow such a curve. It plays an important part in constructing portfolios. Apart from finance, a lot of real-life parameters are found to be following such a distribution. Like for example, if we try to find the height of students in a class or the weight of the students in a class, the observations are distributed normally. Similarly, the marks of an exam also follow the same distribution. It helps to normalize marks in an exam if most students scored below the passing marks by setting a limit of saying only those failed who scored below two standard deviations.

Recommended Articles

This has been a guide to the Normal Distribution and its definition. Here we discuss the formula to calculate normal distribution along with the practical examples and downloadable excel sheet. You can learn more about financing from the following articles –

  • POISSON.DIST Function
  • Poisson Distribution Formula
  • Calculate Standard Normal Distribution
  • Binomial Distribution Formula
0 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

Login

Forgot Password?

WallStreetMojo

Download Normal Distribution Formula Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More