Results 1 to 8 of 8
  1. #1
    Star Lounger
    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.

  2. #2
    Star Lounger
    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 y-axis in a third (if applicable), and graph it. This is so obvious, I wonder if there is a complication you have not mentioned.

  3. #3
    Star Lounger
    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 pre-packaged control...like a date picker or the such to incorporate to the application.

  4. #4
    Bronze Lounger
    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>

  5. #5
    Star Lounger
    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 pre-packaged utility.

  6. #6
    Bronze Lounger
    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 MS-Excel 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>

  7. #7
    3 Star Lounger
    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 x-y 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.

  8. #8
    3 Star Lounger
    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 pre-package utilities. There are a couple that I have used, but I don't think they are very good. Stat Pro is an excel add-in by Chris Albright is good on stats, but not as good on the charts.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •