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

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

## What is Normal Distribution Formula?

A distribution is said to be following a normal distribution when it is symmetric i.e. positive values and the negative values of the distribution can be divided into equal halves. 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

If a distribution is normally distributed than the mean, median and mode of the distribution will be equal. A normal distribution has two tails one is known as the right tail and the other one is known as the left tail. For determining the normal distribution of a variable it is important to know its mean and its variance.

A normal distribution 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 very important to standardize the observations in order to be able to compare that. It is done with the help of the z-score. 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- µ)/ α**

Where

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

### Explanation of Normal Distribution Formula

A distribution is said to be following a normal distribution when the distribution follows a bell curve. It is known as the bell curve as it takes the shape of the bell. A distribution is normal when it has certain characteristics in it. 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 very important characteristic of the variable being normally distributed is that the observations will be within 1 standard deviation of the mean 90% of the times. 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.

4.9 (927 ratings)

### Examples of Normal Distribution Formula (with Excel Template)

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

#### Example #1

**Let’s understand the concept of normal distribution with the help of an example. The mean of the weights of a class of student is 65kg and the standard of the weight is .5 kg. If we assume that the distribution of the return is normally distributed than let us interpret the distribution for the weight of the students in the class**.

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

Given,

- The mean return for the weight will be 65 kgs
- Standard deviation will be 3.5 kgs

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

**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 student is 65kg and the standard of the weight is 3.5 kg. If we assume that the distribution of the return is normally distributed than let us interpret the distribution for the weight of the students in the class.**

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

Given,

- The mean return for the weight will be 65 kgs
- Standard deviation will be 3.5 kgs

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

**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 student is 65kg and the standard of the weight is 3.5 kg. If we assume that the distribution of the return is normally distributed than let us interpret the distribution for the weight of the students in the class.**

When a distribution is normally distributed then 68% of the distribution lies within 1 standard deviation, 95% of the distribution lies within 2 standard deviations and 99% of the distribution lies with 3 standard deviation

Given,

- The mean return for the weight will be 65 kgs
- Standard deviation will be 3.5 kgs

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 of Normal Distribution Formula

The normal distribution is a very important statistical concept, as most of the random variables in the world of finance are distributed normally. Normal distribution plays an important part in constructing portfolios. Apart from finance a lot of real-life parameters are found to be following a normal 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 a normal distribution. It helps to normalize marks in an exam if most of the students scored below the passing marks by setting a limit of saying only those failed who scored below two standard deviations.

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

### Recommended Articles

This has been a guide to Normal Distribution Formula. Here we will do the calculation of normal distribution along with the practical examples and downloadable excel sheet. You can learn more about financing from the following articles –

- Poisson Distribution Formula
- Hypergeometric Distribution
- What is Standard Normal Distribution Formula?
- Create Lognormal Distribution in Excel
- Create Normal Distribution Graph in Excel
- What is Binomial Distribution Formula?

- 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