Creating a Distribution Curve in Excel

[soul5]

Hi I'm trying to make a distribution curve in excel, but I can't seem to find it. I have excel 2003 I know how to make column graphs and stuff, but I can't seem to find where to find how to make a distribution curve can anyone help me?


Here is a link of the type of graph I want to make.

http://www.tushar-mehta.com/excel/charts/normal_distribution/images/normal2.gif

Please and Thank you for the help.

 

[rty640]

http://nontrivialexercises.com/2006/09/drawing-a-distribution-curve-in-excel/

 

[berkeman]

http://nontrivialexercises.com/2006/09/drawing-a-distribution-curve-in-excel/

Wow, great link. Thanks.

I didn't read the link closely enough to tell, but it may also be that you have to install the part of Excel that has the Frequency function. It might come in the standard Install package, or it might be in one of the optional Math or Engineering Install options. So if you don't see the Frequency function in the function list on your Excel, check the Install CD to see if you can add it in.

 

[minger]

Alternatively you can go to your Add-ins (under Tools I believe) and enable to "Data Analysis" Add-in (requires no cd). Then, under Tools > Data Analysis there at the bottom of the list, there will be Histogram.

You need to create an array for your "bounds". Then select your data, your bounds, and it outputs the frequency next to the bounds. From there you can bar/line graph whatever.

The FREQUENCY command is a little "cleaner", but the data analysis has some other nice little features in it. Check it out.