
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!!!!!!!!!!!!

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.

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'.

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!!!!!!!!

Quote:
Originally Posted by
frozenflames 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?

Good reference book for Regression study