Results 1 to 8 of 8

Math Help - Real life problem

  1. #1
    Newbie
    Joined
    Mar 2009
    Posts
    4

    Real life problem

    I think this is the right forum; I've been out of high school for 10 years but I can't remember any of this stuff. I have these three data sets, taken from my real life travels:

    Ohio:
    Number of Counties: 88
    Average Size per county: 465.33 square miles
    Time to traverse all 88 counties: 84874 seconds

    Alabama:
    Number of Counties: 67
    Average Size per county: 757.48 square miles
    Time to traverse all 67 counties: 76482 seconds

    Delaware:
    Number of Counties: 3
    Average Size per county: 651.67
    Time to traverse 3 counties: 2700 seconds

    I would like to calculate an equation that, if given the number of counties and average size per county of a state, I could calculate how long it would take to traverse all the counties of that state.

    Thanks
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Mar 2009
    Posts
    20


    What is the source of this data? Are all three independent? I thought at first that maybe it was a calculation, like 84874/88 = 465.33 but that's definitely not the case.

    There's no linear equation that will map three different variables. If you want to do just two you could do that. Otherwise it gets really complicated I think.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Mar 2009
    Posts
    4
    Unfortunately I'm looking for the complicated answer, because it's not linear. These are independent data points that I have collected myself.

    When I tried to solve the first two linearly (Ohio & Alabama), the answer for Delaware was over 9 hours, so I knew that couldn't be right.
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Newbie
    Joined
    Mar 2009
    Posts
    20
    Ok, I see now. What you're looking for is non-linear regression (more than 2 variables). I know that Microsoft Excel has some good functions for linear regression (just two variables) but have never used it for more than two.

    I would just try a search for "non-linear regression software" or something similar. That may help you identify an equation that might give you a rough idea. I can guarantee you that you won't find a 100% perfect line of fit. I assume you're just looking for something close.

    Hope this helps.
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Newbie
    Joined
    Mar 2009
    Posts
    4
    That helps a lot! I'll look into it, thanks!
    Follow Math Help Forum on Facebook and Google+

  6. #6
    Newbie
    Joined
    Mar 2009
    Posts
    20
    Regression Tools - Online Nonlinear Regression
    Although I've never used this myself here's a free online tool. You really need to understand the basics of linear regression before diving into non-linear. Look for an example of linear regression with Excel and get an idea of what it does, then look into non-linear.

    Also, the more data points the better. So if you have info for all 50 states you should do it that way for sure.
    Follow Math Help Forum on Facebook and Google+

  7. #7
    Newbie
    Joined
    Mar 2009
    Posts
    4
    I have three values for my set, but non-linear regression only takes two?
    Follow Math Help Forum on Facebook and Google+

  8. #8
    Newbie
    Joined
    Mar 2009
    Posts
    20
    Linear regression - Wikipedia, the free encyclopedia
    The very basics of linear regression is that your goal is to plot all of your X/Y points on a graph and then draw a line through the middle that "fits" them. The equation of that line is a guideline for how your data behaves and based on any given value of X you should be able to predict Y with at least some accuracy.

    The problem is that visually it's easy to plot X and Y because there are only two dimensions. If you have an X, Y, and Z (as you do) it's hard to map it out on paper.

    Check the link above for linear to get the basics, then check out this one:

    Nonlinear regression - Wikipedia, the free encyclopedia
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Real life problem My life plz help
    Posted in the Math Topics Forum
    Replies: 1
    Last Post: September 30th 2010, 02:44 AM
  2. Real life geometry problem
    Posted in the Geometry Forum
    Replies: 2
    Last Post: July 2nd 2010, 07:52 AM
  3. Real life problem
    Posted in the Statistics Forum
    Replies: 0
    Last Post: April 4th 2010, 11:52 PM
  4. Real Life Problem
    Posted in the Business Math Forum
    Replies: 1
    Last Post: May 24th 2009, 11:30 AM
  5. Real Life Expectation Problem.
    Posted in the Statistics Forum
    Replies: 1
    Last Post: March 20th 2009, 03:51 PM

Search Tags


/mathhelpforum @mathhelpforum