Results 1 to 7 of 7

Thread: How to model this graph ?

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    4

    How to model this graph ?

    Dear Fellows,

    Please guide me that how can I describe the following graph mathematically ?

    I want to implement this function in excel ..

    Please find the graph in attachement and help me to write equation for this graph ..

    Thank you for consideration.

    Best wishes.
    Attached Images Attached Images  

  2. #2
    Fanatic Member VBAhack's Avatar
    Join Date
    Dec 2004
    Location
    Sector 000
    Posts
    617

    Re: How to model this graph ?

    Welcome to the forums!

    I think the most important question to ask is: how were the data points in the plot generated? That should provide some clue as to an appropriate function.

  3. #3

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    4

    Re: How to model this graph ?

    Hello ..

    Thanx for the welcome message ..

    These points are the result of experimental data.

    As this graph shows the result probability of that experiement, I want to drive its relation mathematically.

    Best regards.

  4. #4
    Fanatic Member VBAhack's Avatar
    Join Date
    Dec 2004
    Location
    Sector 000
    Posts
    617

    Re: How to model this graph ?

    OK, that's helpful. There are multiple approaches you can take, depending on what you are ultimately trying to do. Is it interpolation between data points? If so, then you really don't need to fit a function to the entire data set, just the points in the vicinity of where you want to interpolate.

    You could also fit the data points with a series of cubic splines, which would result in a smooth curve but wouldn't result in a single equation for all data points, but rather multiple equations depending on the value of x.

    If you really need a single equation to fit all the data (hard to imagine why), one possibility is to fit an n-1 order polynomial to the n data points. Other options are least squares fitting to various functions (won't likely be an exact fit), but choosing the function to try is perhaps more art than science. Other than an exact polynomial fit, I know of no way to magically derive a function to model a set of data. Lots of trial and error. One possibility is some sort of exponential function like this:

    http://www.itl.nist.gov/div898/strd/...a/gauss3.shtml

    If you can post a file with your data points, I'd be willing to play around a bit.

  5. #5
    vbuggy krtxmrtz's Avatar
    Join Date
    May 2002
    Location
    In a probability cloud
    Posts
    5,573

    Re: How to model this graph ?

    Looking at the graph I think it could be a sum of 3 peaks of different width (at half the maximum height) and height. So maybe you should start by trying to model a single peak, maybe a normal distribution. But perhaps my guess is not too educated.
    Lottery is a tax on people who are bad at maths
    If only mosquitoes sucked fat instead of blood...
    To do is to be (Descartes). To be is to do (Sartre). To be do be do (Sinatra)

  6. #6
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863

    Re: How to model this graph ?

    Quote Originally Posted by hawk80
    These points are the result of experimental data.
    The graph does show points marked with a point (or whatever), what do those points stand for?
    How often did your run the experiment? Since the graph doesn't look like a normal distribution, the number of trials might to too low.

    Could you post the actual values for the probability that you used for this graph (helps us "making" a formula).
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button


    Wait, I'm too old to hurry!

  7. #7

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    4

    Re: How to model this graph ?

    Dear fellows,

    Thanx a million for all of your replies. They are really helpful.

    Best regards.

Posting Permissions

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



Click Here to Expand Forum to Full Width