Fine Beautiful Create A Normal Distribution Curve In Excel
This is the probability density function for the normal distribution in Excel.
Create a normal distribution curve in excel. The above chart is the normal distribution graph. 100 points will be created for a nice smooth curve. Before we go further please note that this is an Excel blog and not a statistics blog.
The bell curve looks nice when it covers the full 6 standard deviations. Click Kutools Charts Data Distribution Normal Distribution Bell Curve. In the cell below it enter 36 and create a series from 35 to 95 where 95 is Mean 3 Standard Deviation.
The chart may seem a bit off first. Therefore Im not going to spend much time on. Click here to download the MBA Excel Normally Distributed Random Number Generator Template.
We will compute the corresponding y-values to the x-values between 145 and 205 as this covers the entire x-range of the histogram. Select the data range you will create a bell curve based on and click Kutools Charts Normal Distribution Bell Curve. Name one of these Control one Data and the other Report.
Select the data points and normal distribution values then insert an X-Y Scatter chart. Set up the x-axis values for the curve. However this page came about because I have often been asked specifically how to create a Normal distribution curve in Excel.
There are many ways to create the graph using line. To make the table a normal distribution graph in excel select the table columns Marks and Normal distribution. To make a normal distribution graph go to the Insert tab and in Charts select a scatter chart with smoothed lines and markers.