Normal Distribution Curve over Histogram

[Vikas Kumar]

Hi All,

Can anyone please guide me on how to plot a normal curve over a histogram in Excel 2010. Plesae see attached file for more details on my question. I know how to create the histogram but not really sure how the curve is plotted over the histogram.

Thanks in advance.

Regards
Vikas

 

[Debraj]

Hi Vikas,

Welcome to the forum..

Did you checked those links..

http://excelgraphs.blogspot.in/2013/03/historgrams-and-overlayed-normal-curves.html
http://stackoverflow.com/questions/11545505/mac-excel-2011-histogram-with-normal-distribution

If you face any issue to adapt... just raise your hand.. we are here to help you..

 

[Vikas Kumar]

Hi Debraj,

Thanks heaps for posting the links. I followed the steps as explained however could not plot the normal curve neatly over the histogram due to massive variation in the values of Y axis between frequency column and Normal distribution. Looking further into this I realised, the file I attached to this thread used Polynomial trendline instead of normal curve, apologies for my mistake. However it was a very good practice for me to going through the links you posted as I used this information for a different project.

Thanks again for your help.

Regards
Vikas