Results 1 to 8 of 8

20030718, 14:21 #1
 Join Date
 Sep 2002
 Location
 Detroit, Michigan, USA
 Posts
 92
 Thanks
 0
 Thanked 0 Times in 0 Posts
Guass normal distribution curve (XL2000)
Is someone aware of the existence of a control or utility capable of displaying the Gauss normal distribution curve (the actual graphic) based on data on a certain range?. All the formulae to get the stats is there but...I can't find the graphic part of it...
Thanks in advance.

20030718, 14:28 #2
 Join Date
 Dec 2001
 Location
 Houston
 Posts
 71
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Guass normal distribution curve (XL2000)
If you have the formula, the data, and Excel, that is all that is needed. Run your data in one column, the estimated values based on the formula in another, your yaxis in a third (if applicable), and graph it. This is so obvious, I wonder if there is a complication you have not mentioned.

20030718, 14:34 #3
 Join Date
 Sep 2002
 Location
 Detroit, Michigan, USA
 Posts
 92
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Guass normal distribution curve (XL2000)
Well...it's a little less than obvious....the formulae available in Excel are stat variables (avg, variances and the such...). not exactly what you'd use to plot the graph where you need a y= f(x) approach. Also, the idea was to find a prepackaged control...like a date picker or the such to incorporate to the application.

20030718, 14:43 #4
 Join Date
 Jun 2001
 Location
 New York, New York, Lebanon
 Posts
 1,449
 Thanks
 1
 Thanked 1 Time in 1 Post
Re: Guass normal distribution curve (XL2000)
<img src=/S/hello.gif border=0 alt=hello width=25 height=29> miloguero
Not understanding what exactly you are trying to do, chart, or find a formula, I have found these by simply searching the OLH and the MSKB using the string "Gauss normal distribution curve"
OK check the functions:
NORMSDIST
NORMSINV
NORMINV
NORMDIST
I also found these two MSKB articles that might be helpful:
XL: How to Create a Bell Curve Chart
HOW TO: Create a Normal Chart from a PivotTable in Excel 2000
I hope these work for you. If not post a reply with more details.
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

20030718, 14:50 #5
 Join Date
 Sep 2002
 Location
 Detroit, Michigan, USA
 Posts
 92
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Gauss normal distribution curve (XL2000)
Basically what I was looking for was an ActiveX control that could take as an argument the data range of a certain worksheet. Granted, there are several ways to do it. Controls are easier to handle programmatically and I lend themselves to the kind application I am working on. Also the articles were useful....I just wondered if there was out there a prepackaged utility.

20030718, 15:50 #6
 Join Date
 Jun 2001
 Location
 New York, New York, Lebanon
 Posts
 1,449
 Thanks
 1
 Thanked 1 Time in 1 Post
Re: Gauss normal distribution curve (XL2000)
<img src=/S/hello.gif border=0 alt=hello width=25 height=29> milonguero
OK Try and search for ActiveX controls at the MS Download Center or possibly post your message in the Software Finds and Wants.
I don't know if there is such a thing, because MSExcel does have its own charting engine, but as my idol James Bond 007 said, Never Say Never.
Best of luck
Wassim aka Mister Kiss Kiss Bang Bang<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

20030718, 16:43 #7
 Join Date
 Jun 2001
 Location
 Lawrence, Kansas, USA
 Posts
 202
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Gauss normal distribution curve (XL2000)
I frequently make Gaussian charts using the NORMDIST function to generate the y values for an xy smooth line chart.
For the x values, I typically start 4 standard deviations below the mean and end at 4 standard deviations about the mean.
Generally, I specify the mean and standard deviation from data or another source, the find the beginning value and the ending value. Assuming you need approximately 200 values to get a smooth curve, I calculate the interval needed for the intermediate x values. Next calculate the height of the normal curve at each point using =Normdist(value, mean, standard devation, false). Use false for a pdf probability distribution function) and true for a cdf ( cumulative distribution function).
I've attached an example spreadsheet.

20030718, 16:52 #8
 Join Date
 Jun 2001
 Location
 Lawrence, Kansas, USA
 Posts
 202
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Gauss normal distribution curve (XL2000)
I didn't really address the question about prepackage utilities. There are a couple that I have used, but I don't think they are very good. Stat Pro is an excel addin by Chris Albright is good on stats, but not as good on the charts.