Normal Distribution Curve in Excel

gdazza

New Member
Joined
May 13, 2002
Messages
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. ?
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
Ignore my contribution, use Jay's solution, I didn't read your question carefully enough, doh!

RET79
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top