How can I add a Normal Distribution Bell Curve to an Excel Histogram?
- Thread starter Manix
- Start date
Elsmar Forum Sponsor
W
wmarhel
D
Darius
This may be of some help, I just did it for fun. 
If more soft curve needed, you need more classes (not necesary the histogram ones), like this is more a frecuency polygon, but it's the idea.
If more soft curve needed, you need more classes (not necesary the histogram ones), like this is more a frecuency polygon, but it's the idea.
Last edited by a moderator:
Have you looked at the EXCEL function "NORMDIST"?Manix said:Can anyone tell me how you can add a normal distribution bell curve to an excel histogram?
I have finally figured the histogram but cannot get a bell curve on it!!!!!
NORMDIST
Returns the normal cumulative distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing.
Syntax
NORMDIST(x,mean,standard_dev,cumulative)
X is the value for which you want the distribution.
Mean is the arithmetic mean of the distribution.
Standard_dev is the standard deviation of the distribution.
Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORMDIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.
Remarks
· If mean or standard_dev is nonnumeric, NORMDIST returns the #VALUE! error value.
· If standard_dev < or = 0, NORMDIST returns the #NUM! error value.
· If mean = 0 and standard_dev = 1, NORMDIST returns the standard normal distribution, NORMSDIST.
· The equation for the normal density function is:
Example
NORMDIST(42,40,1.5,TRUE) equals 0.908789
Here's an actual excel file with a normal curve in it (using normdist).
C
cyberspider
May be this is what you are looking...
Try putting Data in 'A' column of Sheet 2 (2), you can watch the result in the 'chart' Sheet.
I will be happy to know if this served the purpose.
Try putting Data in 'A' column of Sheet 2 (2), you can watch the result in the 'chart' Sheet.
I will be happy to know if this served the purpose.
Q
Qaware
Step by step instruction
Hello all you quality freaks out there!
I browsed the links above and found a step by step instruction on how to fit a normal distribution curve to a set of data in Excel. Sometimes Microsoft can actually help you
https://support.microsoft.com/?kbid=213930
Hello all you quality freaks out there!
I browsed the links above and found a step by step instruction on how to fit a normal distribution curve to a set of data in Excel. Sometimes Microsoft can actually help you
https://support.microsoft.com/?kbid=213930
C
cyberspider
Watch out !!!
It's good to appriciate MS what MS has taken is a simulated data with near perfect normal distribution. In real world , asymetric data will stare in your face. If you try some real world data using MS example and use MiniTab's Descriptive statictics, you might get a different scenerio altogather...That is why I have posted above xls file to help you out , when you face real life data.
It's good to appriciate MS what MS has taken is a simulated data with near perfect normal distribution. In real world , asymetric data will stare in your face. If you try some real world data using MS example and use MiniTab's Descriptive statictics, you might get a different scenerio altogather...That is why I have posted above xls file to help you out , when you face real life data.
Slim Pickins
Starting to get Involved
I know this is an old thread, but I recently had the same question. I was looking for something quick and easy to look at my data with. After reading a zillion things, I came up with the attached. My data allows the use of the nominal dimension because I want to see the shift in my process, but you could easily add the mean to reflect your actual data. I also set up the bins to center on the nominal (or mean) with a span of .001. This can easily be changed by editing the formulas above and below the center.
Just fill in the green blocks with your data. Data can be entered from A6 to A550 to be calculated (I didn't make them all green). If you need more, you will need to change the count array. Everything else will happen like magic!
Hope this helps! If nothing else, it might get you in the right direction.
, I came up with the attached. My data allows the use of the nominal dimension because I want to see the shift in my process, but you could easily add the mean to reflect your actual data. I also set up the bins to center on the nominal (or mean) with a span of .001. This can easily be changed by editing the formulas above and below the center.Just fill in the green blocks with your data. Data can be entered from A6 to A550 to be calculated (I didn't make them all green). If you need more, you will need to change the count array. Everything else will happen like magic!
Hope this helps! If nothing else, it might get you in the right direction.
R
Relain
TY TY TY TY TY TY TY TY , I saw the normdist func, but couldnt quite get it, you made me look again and I figured it out.
Similar threads
