In addition, the Yellow line signifies the mean of the data in the bell curve.

Then, we add the Bell Curve as a Chart Title to our curve.

Next, we have to add Straight Lines from the Shape to dictate the standard deviation in the bell curve.

Here, we get the Chart Elements by clicking on the Plus Sign.

Next, you have to uncheck Gridlines and Vertical Axis.

Next, you have to set the Minumum Bounds to 30 and Maximum Bounds to 85 as shown below:.

First of all, double-click on the horizontal axis and it will bring the Format Axis dialog box.

As a consequence, we will be able to get our basic bell curve.

Select Insert Scatter (X, Y) or Bubble Chart, and finally select Scatter with Smooth Lines.

Firstly, select the range of the cells D5:E12.

Now, we are going to create the bell curve. Step 5: Creating Bell Curve with Mean and Standard Deviation in Excel

As a consequence, you will get the following Normal Values column.

Moreover, we have set cumulative to False to ensure we will get the ‘probability density function’.

This formula returns the normal distribution for the given mean and standard deviation. First of all, to determine the mean, we will use the following formula in the cell H5:.We want to use the AVERAGE function to determine the mean value. Now we are going to determine the mean for creating a bell curve. For further calculations, we have inserted the columns Values and Normal Values.Here, we have the Student Name and Score in the following dataset.In the following image, we can see the basic outlines of the bell curve and its related dataset.Here, we have created the basic outlines of creating a bell curve with mean and standard deviation in Excel.

We use the Microsoft Office 365 version here, but you can utilize any other version according to your preference. You should learn and apply all of these to improve your thinking capability and Excel knowledge. This section provides extensive details on this method. In the following section, we will use one effective and tricky method to create a bell curve with mean and standard deviation in Excel. On the other hand, if the value of standard deviation is high, it means the values are distributed in a larger range. If the value of standard deviation is low it means that the values are close to the mean value. Generally, the standard deviation in statistics measures the amount of variation or distribution in a set of numbers. Generally, the mean means the central tendency of a probability distribution in statistics. An equal distribution of values across a data set is meant by the mean. We define the mean as the average of a set of values. Finally, 99.7% of the distribution lies within three standard deviations of the mean.Moreover, 95.5% of the distribution falls within two standard deviations of the average.According to the data, 68.2% of the distribution is within one standard deviation of the mean.Additionally, it indicates that the probability is much lower for extreme values (i.e highest or lowest) The peak on this curve represents the mean score. When we review scores from an exam, we typically find that the majority of the numbers are in the middle. This is also known as the Normal Distribution Curve. There is a graph that shows the normal distribution of a variable called the Bell Curve.

Plot mean and standard deviation excel