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!!!!! :bonk:

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!!!!!

Try these sites:

ExcelForum (http://www.excelforum.com/archive/index.php/f-6-p-3.html)

Microsoft Support (http://support.microsoft.com/kb/q213930/)

Excel How-to Articles (http://www.kayodeok.btinternet.co.uk/favorites/kbofficeexcelhowto.htm)

This may be of some help, I just did it for fun. :read:

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.

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!!!!! :bonk:Have you looked at the EXCEL function "NORMDIST"?

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).

:bigwave:

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.

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 :rolleyes:

http://support.microsoft.com/?kbid=213930

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.