Question: A study was conducted to build a regression model to predict miles per gallon (MPG) of vehicles. To develop the model, you obtained MPG of

A study was conducted to build a regression model to predict miles per gallon (MPG) of vehicles. To develop the model, you obtained MPG of 43 random vehicles. In addition, you collected the following information (see "Homework # 5 data" Excel file):

- Length: vehicle length (inches)

- Width: vehicle width (inches)

- Weight: vehicle weight (pounds)

- Made in Japan: whether manufactured in Japan or not

Fit a multiple regression model using all four independent variables. For made in Japan variable create an indicator/dummy variable with not made in Japan as the reference/baseline group.

(a) Provide the equation of the line fit

a.

b.

c.

d.

What proportion of variability in the dependent variable is explained by the independent variables?

a.

67.14%

b.

68.21%

c.

65.77%

d.

70.27%

Is the regression model statistically significant?

a.

No, because the p-value for the F-test is less than alpha

b.

Yes, because the p-value for the F-test is greater than alpha

c.

No, because the p-value for the F-test is greater than alpha

d.

Yes, because the p-value for the F-test is less than alpha

Is the variable "width" a significant predictor of MPG?

a.

Yes, because zero is not a possible value within the lower and upper limits of the confidence interval

b.

No, because zero is not a possible value within the lower and upper limits of the confidence interval

c.

Yes, because zero is a possible value within the lower and upper limits of the confidence interval

d.

No, because zero is a possible value within the lower and upper limits of the confidence interval

Is the variable "weight" a significant predictor of MPG?

a.

No, because its p-value is less than alpha

b.

Yes, because its p-value is greater than alpha

c.

Yes, because its p-value is less than alpha

d.

No, because its p-value is greater than alpha

MPG of 43 Randomly Selected Vehicles
Obs MPG Length Width Weight Made in Japan
1 20 192 69 3450 Yes
2 23 183 59 3320 Yes
3 19 176 69 3390 No
4 20 195 73 3350 No
5 18 187 74 4230 No
6 18 201 75 4050 No
7 19 180 74 3255 No
8 14 228 79 4935 No
9 15 192 75 4660 No
10 17 199 79 4660 No
11 18 201 79 4210 No
12 13 228 80 5300 No
13 13 206 79 5900 No
14 26 168 67 2760 No
15 15 192 75 4660 No
16 21 190 72 3390 Yes
17 18 201 76 4315 Yes
18 24 177 68 2880 No
19 16 189 77 4295 Yes
20 15 208 76 4965 Yes
21 18 200 83 3805 No
22 25 166 66 2295 No
23 17 175 71 3640 No
24 18 177 68 3390 Yes
25 13 193 76 5000 No
26 18 187 72 3925 Yes
27 19 187 70 3355 Yes
28 17 203 73 4195 No
29 20 200 73 3340 No
30 20 188 69 3285 Yes
31 20 170 72 3345 Yes
32 15 183 72 4270 Yes
33 16 178 70 4315 Yes
34 25 186 70 3095 No
35 28 172 70 2805 No
36 24 185 67 2855 No
37 21 193 70 3575 Yes
38 17 184 70 3590 Yes
39 23 170 68 2570 Yes
40 26 171 70 2985 Yes
41 19 200 77 4120 Yes
42 34 172 68 3045 No
43 20 186 72 3690 No

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!