Normal Distribution Curve in Excel

[gdazza]

Does anybody know how from a set of data to be able to graph the typical "bell curve" to show the distribution of the data, i.e. mean, std deviation, etc. ?

[lars]

It's in the format data series X error bars and Y error bars, you can play with it from there to show what you want the STd dev to be and show.

[RET79]

Hi.

For a N(4,9) put the range in column A from -10 to +10 perhaps in incrememntal steps of 0.1 then copy =normdist(A2,4,3,false) function down colum B next to your range and then use the chart wizard to draw the graph.

This is one way, but I'm sure there is a more elegant solution, perhaps with VBA. Are you looking for a VBA solution?

RET79

[ This Message was edited by: RET79 on 2002-05-14 10:43 ]

[Jay Petrulis]

Hi,

Suppose your raw data is in A1:A100

in B1 type the following

=NORMDIST(A1,AVERAGE($A$1:$A$100),STDEVP($A$1:$A$100),FALSE)

copy down your list and graph the B1:B100 series.

This should get you started.

Bye,
Jay

[RET79]

Ignore my contribution, use Jay's solution, I didn't read your question carefully enough, doh!

RET79

[Jay Petrulis]

On 2002-05-14 10:49, RET79 wrote:
Ignore my contribution, use Jay's solution, I didn't read your question carefully enough, doh!

RET79

Don't take it back! I did the exact same thing you did when I verified that the curve would look right.

The OP will come back to us with whatever else is needed, so all the suggestions were fine.

Bye,
Jay