Distribution Curve in excel


by soul5
Tags: curve, distribution, excel
soul5
soul5 is offline
#1
Feb2-09, 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.tushar-mehta.com/excel/ch...es/normal2.gif

Please and Thank you for the help.
Phys.Org News Partner Science news on Phys.org
Lemurs match scent of a friend to sound of her voice
Repeated self-healing now possible in composite materials
'Heartbleed' fix may slow Web performance
rty640
rty640 is offline
#2
Feb2-09, 05:45 PM
P: 16
http://nontrivialexercises.com/2006/...urve-in-excel/
berkeman
berkeman is offline
#3
Feb2-09, 06:30 PM
Mentor
berkeman's Avatar
P: 39,575
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
minger is offline
#4
Feb3-09, 08:47 AM
Sci Advisor
P: 1,498

Distribution Curve in excel


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.


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 Maxwell-Boltzmann Distribution Curve Introductory Physics Homework 2
normal distribution in excel General Physics 11
Need help on radial distribution on excel!!! Chemistry 1