Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

**Standard Normal Distribution Formula – (Table of Contents)**

## What is the Standard Normal Distribution Formula?

Standard Normal Distribution is a type of probability distribution which 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”.

Z – Score Formula is represented as below-

**Z – Score = ( X – µ ) / σ**

Where,

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

Then we need to derive probability from the above table.

### Explanation of the Standard Normal Distribution Formula

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

- It has an average or says the mean of zero.
- 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 which 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 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 of Standard Normal Distribution Formula (with Excel Template)

Let’s see some simple to advanced examples of standard normal distribution equation to understand it better.

#### Example #1

**Consider 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.

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

Z – score = ( X – µ ) / σ

4.9 (927 ratings)

= (940 – 850) / 100

Z Score will be –

**Z Score = 0.90**

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

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 subject and currently, she has around 100 students enrolled under her. After the 1 ^{st} test she took for her students she got followings average numbers scored by them and have ranked them percentile wise. **

**Solution:**

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

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

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

The calculation of mean can be done as follows-

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 deviation = √[∑(x – x) / (n-1)]

Standard deviation = 16.38

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

Z – score= ( X – µ ) / σ

= (75 – 73.50) / 16.38

Z Score will be –

**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 customers spend figures are normally distributed.**

**Solution:**

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

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

The calculation of z score^{ }can be done as follows-

Z – score= ( X – µ ) / σ

=(26000 – 25000) / 500

Z Score will be-

**Z Score = 2**

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

Standard normal distribution will be-

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

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

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 discuss how to calculate standard normal distribution (Z-score) in excel with practical examples and downloadable excel template. You can learn more about excel modeling from the following articles –

- Explanation of Poisson Distribution Formula
- What is Hypergeometric Distribution?
- Normal Distribution Formula
- Calculation of Binomial Distribution
- Plot Normal Distribution Graph in Excel
- Calculate Frequency Distribution in Excel
- Calculate Covariance

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced

## Leave a Reply