# Normal Distribution Curve in Excel

This is a discussion on Normal Distribution Curve in Excel within the Excel Questions forums, part of the Question Forums category; Does anybody know how from a set of data to be able to graph the typical "bell curve" to show ...

1. 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. ?

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

3. 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 ]

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

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

RET79

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•