WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Standard Normal Distribution Formula

By Harsh KataraHarsh Katara | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Formula to Calculate Standard Normal Distribution

Standard Normal Distribution is a type of probability distribution that is symmetric about the average or the mean, depicting that the data near the average or the mean are occurring more frequently when compared to the data which is far from the average or the mean. A score on the standard normal distribution can be termed as the “Z-score”.

Standard Normal Distribution Formula is represented as below-

Z – Score = ( X – µ ) / σ

Standard Normal Distribution Formula

Where,

  • X is a normal random variable
  • µ is the average or the mean
  • σ is the standard deviation

Z Score

Then we need to derive probability from the above table.

Explanation

The standard normal distribution in order words referred to as the Z-distribution has the following properties:

  1. It has an average or says the mean of zero.
  2. It has a standard deviation, which is equal to 1.

Using the standard normal table, we can find out the areas under the density curve. Z-score is sore on the standard normal distribution and should be interpreted as the number of standard deviations where the data point is below or above the average or the mean.

A negative Z-Score shall indicate a score that is below the mean or the average, while A positive Z-Score shall indicate that the data point is above the mean or the average.

The standard normal distribution follows the 68-95-99.70 Rule, which is also called as the Empirical Rule, and as per that Sixty eight percent of the given data or the values shall fall within 1 standard deviation of the average or the mean, while ninety-five percent shall fall within 2 standard deviations, and finally, the ninety-nine decimal seven percent of the value or the data shall fall within 3 standard deviations of the average or of the mean.

Examples

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

Example #1

Consider the mean given to you like 850, standard deviation as 100. You are required to calculate Standard Normal Distribution for a score above 940.

Solution:

Use the following data for the calculation of standard normal distribution.

Standard Normal Distribution Formula Example1

So, the calculation of z score can be done as follows-

Example1.1

Z – score = ( X – µ ) / σ

= (940 – 850) / 100

Z Score will be –

Standard Normal Distribution Formula Example 1.2

Z Score = 0.90

Now using the above table of the standard normal distribution, we have a value for 0.90 as 0.8159, and we need to calculate the score above that which is P(Z >0.90).

Z Score Example 1

We need the right path to the table. Hence, the probability would be 1 – 0.8159, which is equal to 0.1841.

Thus, only 18.41% of the scores lie above 940.

Example #2

Sunita takes private tuition classes for mathematics subjects, and currently, she has around 100 students enrolled under her. After the 1st test she took for her students, she got the following average numbers, scored by them, and have ranked them percentile-wise. 

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

Solution:

First, we plot what we are targeting, which is the left side of the cure. P(Z<75).

 Example 2

Use the following data for the calculation of standard normal distribution.

Standard Normal Distribution Formula Example 2

For that, we need to calculate the mean and the standard deviation first.

The calculation of mean can be done as follows-

 Example2.1

Mean = (98 + 40 + 55 + 77 + 76 + 80 + 85 + 82 + 65 + 77) / 10

Mean = 73.50

The calculation of standard deviation can be done as follows-

Standard Normal Distribution Formula Example 2.2

Standard deviation = √[∑(x – x) / (n-1)]

Standard deviation = 16.38

So, the calculation of z score can be done as follows-

Example2.3

Z – score= ( X – µ ) / σ

= (75 – 73.50) / 16.38

Z Score will be –

Standard Normal Distribution Formula Example 2.4

Z Score = 0.09

Now using the above table of a standard normal distribution, we have value for 0.09 as 0.5359 and that is the value for P (Z <0.09).

Hence 53.59% of the students scored below 75.

Example #3

Vista limited is an electronic equipment showroom. It wants to analyze its consumer behavior. It has around 10,000 customers around the city. On average, the customer spends 25,000 when it comes to its shop. However, the spending varies significantly as customers spend from 22,000 to 30,000 and the average of this variance around 10,000 customers that management of vista limited has come up with is around 500.

The management of Vista limited has approached you, and they are interested to know what proportion of their customers spend more than 26,000? Assume that customer’s spending figures are normally distributed.

Solution:

First, we plot what we are targeting, which is the left side of the cure. P(Z>26000).

Example 3

Use the following data for the calculation of standard normal distribution.

Standard Normal Distribution Formula Example3

The calculation of z score can be done as follows-

Example3.1

Z – score= ( X – µ ) / σ

=(26000 – 25000) / 500

Z Score will be-

Standard Normal Distribution Formula Example 3.2

Z Score = 2

The calculation of standard normal distribution can be done as follows-

 Example3.3

Standard normal distribution will be-

Standard Normal Distribution Formula Example 3.4

Now using the above table of the standard normal distribution, we have a value for 2.00, which is 0.9772, and now we need to calculate for P(Z >2).

Example3.5

We need the right path to the table. Hence, the probability would be 1 – 0.9772, which is equal to 0.0228.

Standard Normal Distribution Formula Example 3.6

Hence 2.28% of the consumers spend above 26000.

Relevance and Use

To make an informed and a proper decision, one needs to convert all of the scores to a similar scale. One needs to standardize those scores, converting all of them to the standard normal distribution using the Z score method, with a single standard deviation and a single average or the mean. Majorly this is used in the field of statistics and also in the field of finance that too by traders.

Many statistical theories have attempted to model the prices of the asset (in fields of finance) under the main assumption that they shall follow this kind of normal distribution. Price distributions mostly tend to have fatter tails and, hence have kurtosis, which is greater than 3 in real-life scenarios. Such assets have been observed to have the price movements which are greater than 3 standard deviations beyond the average or the mean and more often than the expected assumption in a normal distribution.

Recommended Articles

This has been a guide to Standard Normal Distribution Formula. Here we learn how to calculate standard normal distribution (Z-score) with practical examples and a downloadable excel template. You can learn more about excel modeling from the following articles –

  • Calculate Poisson Distribution
  • Normal Distribution Formula
  • Calculation of Binomial Distribution
  • Formula of Sampling Distribution 
8 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 Standard Normal Distribution Formula Excel Template

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