Bell Curve Graph

[TCL28]

Hi all,
Is there a way to automatically smooth the points on a graph to come up with a true bell curve? I have 50 point A1 thru A50 and when I graph them they look like a bell curve with the exception of some points - I want to show the actual data on the graph and then overlay a heavy red line that show the bell curve? Any help would be greatly appreciated.

Tom

 

[TCL28]

Any takers on this one?

 

[Jay Petrulis]

Relax. No need to bump in such a short time.

Unit normal or non-central? Do you want to match the A1:A50 x-axis coordinates? I'll assume unit normal and matching...

If a1:a50 are your x-coordinates (ascending order), B1:B50 are your y-axis data points, in C1 type

=NORMDIST(A1,0,1,0)

and fill down to C50. Then graph the second series.

Other ways to do this, but try this out and post back if it is not what you need.

 

[AussieRob]

There are some statistical methods you can use but I am not going to try to explain them here.

If you want an easy rough approximation

1. Draw your graph
2. Select the graph line
3. Add Trend Line

Done.

 

[TCL28]

Thank you both - it worked