Results 1 to 2 of 2

Thread: Equation from known data points

  1. #1
    Nov 2008

    Equation from known data points

    Apologies if this is in the wrong section of the forum.

    I’m pretty bad at maths. I need to know a general “thing”. The answer may be pathetically obvious but please be gentle!

    Is it possible to come up with an equation for the trend formed by a number of non-repeating, possibly random points?

    For example, could there be an equation to describe a trend like this:

    In my mathematical ignorance, I doubt there is such an equation.

    The goal is this: from a number of known levels, derive a generic "tendency". I want to be able to play around with different lifestyle factors, to see how they influence a person's (likely) behaviour - specifically, how likely they are to own a car.

    Obviously having the money available will make it more likely that they'll get a car. And age will be involved, etc.

    Now I can trend these two factors separately and get fairly random looking trends.

    What I want to be able to do is say: "let's set everyone's income to $20k and see how that affects their car-buying".
    Or even: "divide salary influence by age influence and plot the resulting likely car ownership"

    Does anyone have any recommendations on how to approach this?

    I don't think it can be done by simply operating on the points along both trends. The trends represent completely different things. For example, 40% of the way along the trends is 44 (for the age graph), and $96k (for the salary graph). If you were to get the median of those two levels, you’d be using a salary of $96k for everyone of age 44, no matter what their real salary was.

    Therefore, I need to turn each trend into a generic “tendency”, a “gear”... and it would seem an equation would be the way to do that. Get the equation for one trend, and you can process the other trend using the equation.

    Or maybe that way is just not possible... so, is this pie-in-the-sky or does anyone know a way to do it?

    Thanks for reading,
    Last edited by Seymour Clufley; Sep 12th 2010 at 10:17 PM. Reason: not broad enough
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Prove It's Avatar
    Aug 2008
    First I would draw a scatterplot of the data to see if it looks like there's a trend. Decide what type of polynomial function you think would best model it (e.g. linear, quadratic, cubic, etc) and then perform that type of least-squares regression.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. [SOLVED] Interpolating z(x,y) data point from 4 data points (rectangular)?
    Posted in the Advanced Applied Math Forum
    Replies: 2
    Last Post: Jun 20th 2011, 06:04 PM
  2. Replies: 0
    Last Post: May 9th 2011, 12:27 PM
  3. 3D surface from data points in matlab
    Posted in the Math Software Forum
    Replies: 3
    Last Post: Dec 25th 2009, 07:43 AM
  4. Simple Grapher wanted to plot 3-d data points...
    Posted in the Math Software Forum
    Replies: 0
    Last Post: Dec 15th 2009, 07:03 PM
  5. Replies: 0
    Last Post: Feb 7th 2009, 08:48 AM

Search Tags

/mathhelpforum @mathhelpforum