Normal Distribution Graph in Excel

Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

A normal distribution graph in Excel represents the normal distribution phenomenon of a given data. This graph is made after calculating the mean and standard deviation for the data and then calculating the normal deviation over it. Although Excel 2013 versions, it is easy to plot the normal distribution graph as it has a built-in function to calculate the normal distribution and standard deviation. The graph is very similar to the bell curve.

Excel Normal Distribution Graph (Bell Curve)

A normal distribution graph is a continuous probability function. We all know what probability is; it is a technique to calculate the occurrence of a phenomenon or a variable. A probability distribution is a function used to calculate a variable’s event. There are two types of probability distributions: discrete and continuous.

The basic idea of a normal distribution is explained in the overview above. By definition, a normal distribution means how evenly the data is distributed. A continuous probability distributionProbability DistributionProbability distribution could be defined as the table or equations showing respective probabilities of different possible outcomes of a defined event or scenario. In simple words, its calculation shows the possible outcome of an event with the relative possibility of occurrence or non-occurrence as required.read more is used to calculate real-time occurrences of any phenomenon. In Mathematics, the equation for a probability distribution is as follows:

Equation for probability Distribution

Seems so complex, right? But Excel has made it easier for us to calculate normal distribution as it has a built-in function in Excel of the normal distribution. So in any cell, we must type the following formula:

Normal Distribution Formula

It has three basic factors to calculate the normal distribution in excelNormal Distribution In ExcelNORMDIST or normal distribution is an inbuilt statistical function of excel that calculates the normal distribution of a data set with mean and standard deviation provided.read more:

  1. X: X is the specified value for which we want to calculate the normal distribution.
  2. Mean: Mean is whereas average of the data.
  3. Standard_Dev: Standard deviation is a function to find the deviation of the data. (It has to be a positive number).

The graph we plot on this data is called a normal distribution graph. It is also known as a bell curve. What is the bell curve? A bell curveBell CurveBell Curve graph portrays a normal distribution which is a type of continuous probability. It gets its name from the shape of the graph which resembles to a bell. read more is a common distribution for a variable, i.e., how evenly a data is distributed. It has some. The chart we plot can be a line or scatter chart with smoothed lines.

Normal Distribution Graph in Excel

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Normal Distribution Graph in Excel (wallstreetmojo.com)

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

How to Make a Normal Distribution Graph in Excel?

Below are the examples of normal distribution graphs in Excel (bell curve).

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

Normal Distribution Graph Example #1

First, we will take random data. For example, in column A, let us take values from -3 to 3. Next, we need to calculate Excel’s mean and standard deviation in excelStandard Deviation In ExcelThe standard deviation shows the variability of the data values from the mean (average). In Excel, the STDEV and STDEV.S calculate sample standard deviation while STDEVP and STDEV.P calculate population standard deviation. STDEV is available in Excel 2007 and the previous versions. However, STDEV.P and STDEV.S are only available in Excel 2010 and subsequent versions. read more

before calculating the normal distribution. Then, we can make the Excel normal distribution graph.

So, have a look at the data below.

Normal Distribution graph Example 1

Follow the below steps:

  1. First, calculate the mean of the data, i.e., an average. Then, in cell D1, we must write the following formula.

    Normal Distribution graph Example 1-1

  2. Press the “Enter” key to get the result.


    Normal Distribution graph Example 1-2

  3. Now, we will calculate the standard deviation for the given data. So in cell D2, we must write the following formula.


    Normal Distribution graph Example 1-4

  4. Press the “Enter” key to get the result.


    Normal Distribution graph Example 1-5

  5. Now in cell B2, we will calculate the normal distribution by the built-in formula for Excel. Write down the following formula in cell B2.


    Normal Distribution graph Example 1-6

  6. The formula returns the result, as shown below:


    Normal Distribution graph Example 1-7

  7. Now, drag the formula to cell B7.


    Normal Distribution graph Example 1-8

  8. In cell B2, we have the normal distribution for the chosen data. To make a normal distribution graph, go to the “Insert” tab, and in “Charts,” select a “Scatter” chart with smoothed lines and markers.


    Normal Distribution graph Example 1-9

  9. When we insert the chart, we see that our bell curve or normal distribution graph is created.


    Normal Distribution graph Example 1-10

The above chart is the normal distribution graph for the random data we took. Now we need to understand something before moving on to a real-life example of data. Standard Deviation S means Standard Deviation Sample because we have a huge chunk of data in real data analysis, and we pick a sample of data from that to analyze.

Normal Distribution Graph Example #2

Moving on to a real-life example. The more the data we have, the smoother line we will get for our bell curve or Excel normal distribution graph. To prove that, we will take an example of employees and their incentives achieved for the current month. Let us take a sample of 25 employees.

Consider the below data.

Normal Distribution graph Example 2
Normal Distribution graph Example 2-1

The mean of the data is 13,000.

Normal Distribution graph Example 2-2
  • Now, let us find the standard deviation for the data. Type the following formula.
Normal Distribution graph Example 2-3

The standard deviation for the data is 7359.801.

Normal Distribution graph Example 2-4
  • As we have calculated both the mean and the standard deviation, we can now calculate the normal distribution for the data. Type the following formula.
apply formula Example 2-5
  • The normal distribution function returns the result, as shown below:
apply formula Example 2-6
  • Next, drag the formula to cell B26.
apply formula Example 2-7
  • Now, as we have calculated our normal distribution, we can go ahead and create the bell curve of the normal distribution graph of the data. But, first, click on the “Scatter” chart with smoothed lines and markers in the “Insert” tab under the “Charts” section.
insert graph Example 2-8
  • When we click “OK,” we see the following chart created:
Normal Distribution graph Example 2-9

We took 25 employees as the sample data. We can see that on the horizontal axis, the curve stops at 25.

The above chart was the normal distribution graph or bell curve for the data for employees and the incentives they achieved for the current month.

Excel normal distribution is a data analysis process requiring few functions, such as the mean and standard deviation of the data. The graph on the normal distribution is known as the normal distribution graph or the bell curve.

Things to Remember About Normal Distribution Graph in Excel

  1. The mean is the average of data.
  2. The standard deviation should be positive.
  3. The horizontal axis represents the sample count we picked for our data.
  4. The normal distribution is also known as the bell curve in Excel.

This article is a guide to the Normal Distribution Graph in Excel. We look at creating a normal distribution graph in Excel with a downloadable Excel template. You may learn more about Excel from the following articles: –

Reader Interactions

Comments

  1. Benjamin Amough Kwembe says

    Your teaching skill is laudable. I used my students exam scores to plot the normal distribution graph. Unfortunately, I couldn’t get a very smooth bell shaped curve.

Leave a Reply

Your email address will not be published. Required fields are marked *