Is there a method to graphing a bell curve from a data series in Excel 2007?
Thanks for your help.
Is there a method to graphing a bell curve from a data series in Excel 2007?
Thanks for your help.
You can check these files
www.grahamseibert.com/MK/math/bell_curve.xls
xnet.rrc.mb.ca/davidg/Excel/bellcurve.xls
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
The link below makes a Histogram (based upon real data - so the chart may not be normally distributed) - you can simply change the chart type to i.e. .ChartType = xlXYScatterLinesNoMarkers - that way it draws a line rather than using bars - you can change the number bins - this will give the curve more or less character. But if you actually want a Bell curve this is not the answer.
http://www.excelfox.com/forum/f12/ma...ing-arrays-14/
xl2007 - Windows 7
xl hates the 255 number
Posting Permissions
Reply With Quote
Bookmarks