Excel Plot Normal Distribution. In the cell below it enter 36 and create a series from 35 to 95 where 95 is Mean 3 Standard Deviation. Normal Distribution shows how the data points are distributed along sides of mean and also showing the standard deviation in both sides of the mean.
Typically you are given the mean and SD values from the start but if thats not the case you. N the following example you can create a bell curve of data generated by Excel using the Random Number Generation tool in the Analysis ToolPak. So to graph this function in Excel well need a series of x values covering μ-3σμ3σ.
This value can be calculated using Mean 3 Standard Deviation 65-310.
Find the standard deviation. Copy the normal values in step 9. It has to be a. Normal distribution graph in excel is a continuous probability function.
