Create Bell Curve Chart

The Bell curve chart is also called as normal probability distributions in Statistics and it will be used to show a plot of normal distribution of a given data set. This post will guide you how to create a chart of a bell curve in Microsoft Excel. And How to save the generated bell curve chart as normal chart template in Excel.

Create Bell Curve Chart

You can refer to the below examples to create a sample bell curve, just do the following steps:

#1 enter the following column headings in a new worksheet (Data, Mean, Standard deviation, Distribution)

The mean is the average value of all the data points in range A2:A10. And the Standard Deviation indicates how much deviates from the mean of the data set.

#2 enter the data in the range A2:A10

#3 enter the formula =AVERAGE(A2:A10) in the formula box of cell B2 to generate the Mean value.

create bell curve chart1

#4 enter the formula =STDEV(A2:A10) in the formula box of cell C2 to generate the standard deviation.

create bell curve chart2

#5 enter the formula =NORM.DIST(A2,$B$2,$C$2,FALSE) in the formula box of cell D2 to generate normal probability distribution. Then drag Auto Fill Handler over other cells from D2 to D10.

create bell curve chart3

create bell curve chart4

#6 select range A2:A10 and D2:D10, then go to INSERT tab, click Scatter with Smooth Lines under charts group.

create bell curve chart5

#7 you will see a bell curve is created.

create bell curve chart5     create bell curve chart6

Save Bell Curve Chart as Chart Template

If you want to save the generated bell curve chart as chart template, just refer to the below steps:

#1 right click on the bell curve chart, select Save as Template… from the pop up menu list.

create bell curve chart7

#2 enter the file name, and click Save button.

create bell curve chart8


Related Functions

  • Excel AVERAGE function
    The Excel AVERAGE function returns the average of the numbers that you provided.The syntax of the AVERAGE function is as below:=AVERAGE (number1,[number2],…)….
  • Excel STDEV Function
    The Excel STDEV function returns the standard deviation of a population based on a sample of numbers. This function has been replaced by the STDEV.S function in Excel 2010.The syntax of the STDEV function is as below:= STDEV (number1,[number2],…)…
Related Posts
Average with Multiple Criteria in Excel
Average with Multiple Criteria 1

AVERAGEIFS function is one of the most popular functions in Excel. Apply AVERAGEIFS function, we can calculate average simply if there are multiple conditions. In this article, we will introduce you to apply AVERAGEIFS function to calculate average of a ...

Average of Top N Values in Excel
Average of Top N Values 1

AVERAGE function is one of the most popular functions in Excel. Apply AVERAGE together with some other functions, we can calculate average properly based on different situations. In this article, we will introduce you the way to calculate average of ...

Average the Last N Numeric Values in Excel
Average the Last N Numeric Values 7

AVERAGE function is one of the most popular functions in Excel. Apply AVERAGE together with some other functions, we can calculate average simply for some complex situations. In this article, we will introduce you to calculate average of the last ...

How to Average Last N Values in Multiple Columns
Average Last N Values in Multiple Columns 14

In Excel there are a lot of built-in functions, and AVERAGE is one of the most frequently used functions. In daily work, we may apply AVERAGE function together with some other functions to get average based on some conditions. In ...

How to Average Ignore Zero Number
How to Average Ignore Zero Number 5

AVERAGE function is a frequently used function in our office work. Except this basic function, Excel also provides some other Average related functions like AVERAGEIF, AVERAGEIFS. In this article, we will show you applying AVERAGEIF function to get average with ...

How to Average the Last N Values in Excel
How to Average the Last N Values 10

In Excel there are a lot of built-in functions, and AVERAGE is one of the most frequently used functions. We can apply it to calculate the average of numbers from a given range reference. In daily work, we may apply ...

How to Calculate Average If Criteria Not Blank/Ignore Blank Cell
How to Calculate Average If Criteria Not Blank 11

In daily work we often need to calculate the average of some numbers based on given conditions or criteria. To calculate average with criteria, we can apply AVERAGEIF of AVERAGEIFS function. AVERAGEIFS function can handle more than one group of ...

How to Calculate Average Ignore Non-Numeric Values and Errors
How to Calculate Average Ignore Non-Numeric Values and Errors 8

In daily work we often need to calculate the average of some numbers in a range for further analysis. Thus, we need to know some basic functions of calculate average in Excel. From now on, we will introduce you some ...

How to Average and Ignore Errors in Excel
average and ignore errors2

This post will guide you how to average a list of values and ignoring any errors in the given range in Excel 2013/2016 or Excel office 365. You can use the AVERAGEIF function or AGGREGATE function to calculate the average ...

How to Calculate Average Ignore Blank and Zero Cells in Excel
How to Calculate Average Ignore Blank and Zero Cells in Excel8

Sometimes we need to calculate the average for a list or a range of numbers, but blank cells and zero cells may be also included in the selected range, so if these invalid cells are included, we often get error ...

Sidebar