
#1
Feb209, 04:48 PM

P: 64

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 wanna make. http://www.tusharmehta.com/excel/ch...es/normal2.gif Please and Thank you for the help. 



#2
Feb209, 05:45 PM

P: 16




#3
Feb209, 06:30 PM

Mentor
P: 39,716

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. 



#4
Feb309, 08:47 AM

Sci Advisor
P: 1,498

Distribution Curve in excel
Alternatively you can go to your Addins (under Tools I believe) and enable to "Data Analysis" Addin (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. 


Register to reply 
Related Discussions  
normal distribution curve  Set Theory, Logic, Probability, Statistics  1  
Differential Geometry: Showing a curve is a sphere curve  Calculus & Beyond Homework  0  
Concept with MaxwellBoltzmann Distribution Curve  Introductory Physics Homework  2  
normal distribution in excel  General Physics  11  
Need help on radial distribution on excel!!!  Chemistry  1 