Results 1 to 6 of 6

Math Help - Regression

  1. #1
    Member
    Joined
    Jan 2006
    Posts
    118

    Regression

    A consumer organization wants to develop a regression model to predict gasoline mileage as measured by miles per gallon based on the horsepower of the car’s engine and the weight of the car. A sample of 50 recent car models was selected and the results recorded. .

    MPG Horsepower Weight
    Y X1 X2
    1 43.1 48 1985
    2 19.9 110 3365
    3 19.2 105 3535
    4 17.7 165 3445
    5 18.1 139 3205
    6 20.3 103 2830
    7 21.5 115 3245
    8 16.9 155 4360
    9 15.5 142 4054
    10 18.5 150 3940
    11 27.2 71 3190
    12 41.5 76 2144
    13 46.6 65 2110
    14 23.7 100 2420
    15 27.2 84 2490
    16 39.1 58 1755
    17 28.0 88 2605
    18 24.0 92 2865
    19 20.2 139 3570
    20 20.5 95 3155
    21 28.0 90 2678
    22 34.7 63 2215
    23 36.1 66 1800
    24 35.7 80 1915
    25 20.2 85 2965
    26 23.9 90 3420
    27 29.9 65 2380
    28 30.4 67 3250
    29 36.0 74 1980
    30 22.6 110 2800
    31 36.4 67 2950
    32 27.5 95 2560
    33 33.7 75 2210
    34 44.6 67 1850
    35 32.9 100 2615
    36 38.0 67 1965
    37 24.2 120 2930
    38 38.1 60 1968
    39 39.4 70 2070
    40 25.4 116 2900
    41 31.3 75 2542
    42 34.1 68 1985
    43 34.0 88 2395
    44 31.0 82 2720
    45 27.4 80 2670
    46 22.3 88 2890
    47 28.0 79 2625
    48 17.6 85 3465
    49 34.4 65 3465
    50 20.6 105 3380



    a. State the multiple regression equation.
    b. Interpret the meaning of the slopes b1 and b2 in his problem.
    c. Explain why the regression coefficient b0 has no practical meaning in the context of his problem.


    PLEASE HELP!!!!!!!!!!!!
    Last edited by frozenflames; February 6th 2008 at 02:57 PM.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Aug 2007
    From
    USA
    Posts
    3,110
    Thanks
    2
    I think the question is why you have shown no effort in solving your homework problem.

    The initial analysis took me all of 2 minutes in MS Excel, using the Data Analysis AddIn. The results seem quite reasonable, with both coefficients being negative. The rest is just looking at the data.

    Where are you struggling? Surely you have appropriate software for this sort of thing. Didn't your course requirements include such a purchase? It is a very common practice.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    MHF Contributor
    Joined
    Aug 2007
    From
    USA
    Posts
    3,110
    Thanks
    2
    You present a very common point. You may be 1000 times more sincere than the last 1000 people to have posted such language. My point is, why are you attempting such analysis without any background? Get some background. Otherwise, why would anyone want to read your report?

    Are you in a class? Do you have a book? Where did you get this problem? If you truly have as little clue as you seem to be indicating, you have no business with such an investigation.

    My views. I welcome others'.
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Member
    Joined
    Jan 2006
    Posts
    118
    Okay so hear is what I have thus far:

    a. MPG = 58.157 - .118HP (B1) - .00687Weight (B2)
    b. Both B1 and B2 are negative; thereby, signifying a perfectly linear relationship?
    c. ?

    B & C is all I need...please HELP!!!!!!!!
    Follow Math Help Forum on Facebook and Google+

  5. #5
    MHF Contributor
    Joined
    Aug 2007
    From
    USA
    Posts
    3,110
    Thanks
    2
    Quote Originally Posted by frozenflames View Post
    Okay so hear is what I have thus far:

    a. MPG = 58.157 - .118HP (B1) - .00687Weight (B2)
    b. Both B1 and B2 are negative; thereby, signifying a perfectly linear relationship?
    c. ?

    B & C is all I need...please HELP!!!!!!!!
    That's the spirit...

    a) I didn't check your arithmetic, but it looks reasonable.

    b) Negative = "perfectly linear"? No. You have a linear model. Of course you are going to get a linear relationship. You can't get anything else. Negative means only that the gas mileage decreases as weight or HP increases. For real studies, one must also take into account the probability that the parameter might actually be zero (0). That's a study for another day.

    c) Put in zero (0) for HP and Weight and determine the MPG. Does it make any sense?
    Follow Math Help Forum on Facebook and Google+

  6. #6
    Banned
    Joined
    Jan 2008
    Posts
    13

    Good reference book for Regression study

    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Ncaaf multiple regression/ stepwise regression
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: August 10th 2011, 06:21 AM
  2. Regression SS in multiple linear regression
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: June 20th 2009, 12:23 PM
  3. regression help
    Posted in the Advanced Math Topics Forum
    Replies: 1
    Last Post: October 14th 2008, 11:25 PM
  4. Help with Regression
    Posted in the Advanced Statistics Forum
    Replies: 3
    Last Post: December 7th 2007, 04:56 AM
  5. regression
    Posted in the Advanced Statistics Forum
    Replies: 3
    Last Post: July 8th 2007, 10:55 AM

Search Tags


/mathhelpforum @mathhelpforum