b Consider the addition of the dummy variable FuelPremium wh

b. Consider the addition of the dummy variable FuelPremium, where the value of FuelPremium is 1 if the required or recommended type of fuel is premium gasoline and 0 if the type of fuel is regular gasoline. Develop the estimated regression equation that can be used to predict the fuel efficiency for highway driving given the engine\'s displacement and the dummy variable FuelPremium.

Round your answers to four decimal places. Enter negative values as negative numbers.

c. Use = .05 to determine whether the dummy variable added in part (b) is significant.

Manufacturer Displacement Fuel Drive Hwy MPG
Audi 2.0 Premium F 30
Audi 2.0 Premium F 31
Audi 2.0 Premium F 31
Audi 2.0 Premium F 33
Audi 2.0 Premium A 29
Audi 2.0 Premium A 31
Audi 2.0 Premium A 27
BMW 1.6 Premium F 30
BMW 1.6 Premium F 35
BMW 1.6 Premium F 32
BMW 1.6 Premium F 32
BMW 2.0 Premium R 36
BMW 2.0 Premium R 34
BMW 1.6 Premium A 30
BMW 1.6 Premium A 31
Chrysler Group LLC 2.4 Regular F 29
Ford Motor Company 2.0 Regular F 38
Ford Motor Company 2.0 Regular F 37
Ford Motor Company 2.0 Regular F 36
Ford Motor Company 2.0 Regular F 38
Ford Motor Company 2.0 Regular F 36
Ford Motor Company 2.0 Regular F 40
Ford Motor Company 2.0 Regular F 40
General Motors 2.4 Regular F 32
General Motors 1.4 Regular F 37
General Motors 1.4 Regular F 40
General Motors 1.8 Regular F 35
General Motors 1.8 Regular F 35
Honda 2.4 Regular F 33
Honda 2.4 Regular F 32
Honda 1.8 Regular F 39
Honda 1.8 Regular F 36
Honda 1.8 Regular F 41
Honda 1.5 Regular F 44
Honda 1.3 Regular F 44
Honda 1.3 Regular F 44
Honda 2.4 Premium F 31
Honda 2.4 Premium F 29
Honda 2.4 Premium F 31
Hyundai 1.6 Regular F 40
Hyundai 1.6 Regular F 40
Hyundai 1.6 Regular F 38
Hyundai 1.6 Regular F 40
Kia 2.0 Regular F 34
Kia 2.0 Regular F 33
Kia 2.4 Regular F 31
Kia 2.4 Regular F 32
Kia 1.6 Regular F 40
Kia 1.6 Regular F 40
MAZDA 1.5 Regular F 34
MAZDA 1.5 Regular F 35
MAZDA 2.0 Regular F 33
MAZDA 2.0 Regular F 33
MAZDA 2.5 Regular F 29
MAZDA 2.5 Regular F 28
MAZDA 2.0 Regular F 40
MAZDA 2.0 Regular F 39
Mercedes-Benz 1.8 Premium R 31
Mitsubishi Motors Co 2.0 Regular F 34
Mitsubishi Motors Co 2.0 Regular F 34
Mitsubishi Motors Co 2.4 Regular F 30
Mitsubishi Motors Co 2.4 Regular F 31
Mitsubishi Motors Co 2.4 Regular A 29
Mitsubishi Motors Co 2.0 Premium A 25
Mitsubishi Motors Co 2.0 Premium A 22
Mitsubishi Motors Co 2.0 Premium A 23
Nissan 1.6 Regular F 38
Nissan 1.6 Regular F 36
Nissan 1.8 Regular F 32
Nissan 1.8 Regular F 34
Nissan 1.8 Regular F 31
Subaru 2.0 Regular A 36
Subaru 2.0 Regular A 34
Subaru 2.5 Premium A 25
Subaru 2.5 Premium A 23
Suzuki 2.4 Regular F 30
Suzuki 2.4 Regular F 29
Suzuki 2.4 Regular F 31
Suzuki 2.4 Regular F 31
Suzuki 2.0 Regular F 32
Suzuki 2.0 Regular F 33
Suzuki 2.0 Regular F 30
Suzuki 2.0 Regular F 32
Suzuki 2.4 Regular A 29
Suzuki 2.4 Regular A 30
Toyota 1.8 Regular F 40
Toyota 2.4 Regular F 34
Toyota 2.5 Regular F 31
Toyota 2.5 Regular F 31
Toyota 1.8 Regular F 34
Toyota 1.8 Regular F 34
Toyota 1.5 Regular F 46
Toyota 1.5 Regular F 35
Toyota 1.5 Regular F 38
Volkswagen 2.0 Regular F 29
Volkswagen 2.0 Regular F 34
Volkswagen 2.0 Premium F 31
Volkswagen 2.0 Premium F 32
Volkswagen 2.0 Premium F 33
Audi 3.0 Premium A 28
Audi 3.0 Premium A 27
BMW 3.0 Premium R 33
BMW 3.0 Premium R 30
BMW 3.0 Premium R 31
BMW 3.0 Premium R 33
Chrysler Group LLC 3.6 Regular F 29
General Motors 3.6 Regular R 30
General Motors 3.6 Regular R 29
General Motors 3.6 Regular R 28
Honda 3.5 Regular F 29
Honda 3.5 Regular F 26
Honda 3.5 Premium F 28
Mercedes-Benz 3.5 Premium R 29
Mercedes-Benz 3.5 Premium R 29
Mercedes-Benz 3.5 Premium R 29
Volkswagen 3.6 Premium A 25
BMW 4.4 Premium R 23
BMW 4.4 Premium R 22
BMW 4.4 Premium R 23
BMW 4.4 Premium R 22
BMW 4.4 Premium A 20
General Motors 6.2 Regular R 18
General Motors 6.2 Regular R 24
General Motors 6.2 Regular R 24
General Motors 6.2 Premium R 19
Mercedes-Benz 6.2 Premium R 19
Mercedes-Benz 5.5 Premium R 22
Mercedes-Benz 4.7 Premium R 25
Mercedes-Benz 5.5 Premium R 25
Honda 2.4 Regular F 34
Honda 2.4 Regular F 34
Hyundai 2.0 Regular F 34
Hyundai 2.4 Regular F 35
Hyundai 2.4 Regular F 35
BMW 3.0 Premium R 28
BMW 3.0 Premium R 25
BMW 3.0 Premium R 25
BMW 3.0 Premium A 27
Chrysler Group LLC 3.6 Regular R 27
Chrysler Group LLC 3.6 Regular R 31
Chrysler Group LLC 3.6 Regular R 27
Chrysler Group LLC 3.6 Regular R 31
Chrysler Group LLC 3.6 Regular A 27
Chrysler Group LLC 3.6 Regular A 27
Ford Motor Company 3.5 Regular F 28
Ford Motor Company 3.5 Regular F 27
Ford Motor Company 3.5 Regular F 25
Ford Motor Company 3.5 Regular A 26
Ford Motor Company 3.5 Regular A 25
Ford Motor Company 3.5 Regular A 25
Ford Motor Company 3.7 Regular A 23
General Motors 3.6 Regular F 30
General Motors 3.6 Regular F 30
Honda 3.5 Regular F 30
Hyundai 3.3 Regular F 29
Hyundai 3.8 Regular R 29
Mercedes-Benz 3.5 Premium R 25
Porsche 3.6 Premium R 27
Porsche 3.0 Premium R 30
Toyota 3.5 Regular F 28
Audi 4.2 Premium A 28
BMW 4.4 Premium R 22
BMW 4.4 Premium R 22
BMW 4.4 Premium R 22
BMW 4.4 Premium R 24
BMW 4.4 Premium R 22
BMW 4.4 Premium R 22
BMW 4.4 Premium A 19
BMW 4.4 Premium A 20
BMW 4.4 Premium A 20
BMW 4.4 Premium A 20
BMW 4.4 Premium A 20
Chrysler Group LLC 6.4 Premium R 23
Chrysler Group LLC 6.4 Premium R 23
Hyundai 5.0 Premium R 23
Hyundai 4.6 Premium R 26
Hyundai 5.0 Premium R 26
Hyundai 5.0 Premium R 25
Jaguar Cars 5.0 Premium R 23
Jaguar Cars 5.0 Premium R 21
Jaguar Cars 5.0 Premium R 21
Jaguar Cars 5.0 Premium R 22
Mercedes-Benz 4.7 Premium R 25
Mercedes-Benz 5.5 Premium R 23
Porsche 4.8 Premium R 24
Porsche 4.8 Premium A 24
Porsche 4.8 Premium A 23
Porsche 4.8 Premium A 23
Audi 2.0 Premium F 33
BMW 2.0 Premium R 34
BMW 2.0 Premium A 32
Chrysler Group LLC 2.4 Regular F 30
Chrysler Group LLC 2.4 Regular F 31
Chrysler Group LLC 2.4 Regular F 30
Chrysler Group LLC 2.4 Regular F 31
Ford Motor Company 2.5 Regular F 33
Ford Motor Company 2.5 Regular F 30
Ford Motor Company 2.5 Regular F 29
Ford Motor Company 2.5 Regular F 36
Ford Motor Company 2.5 Regular F 32
Ford Motor Company 2.5 Regular F 36
General Motors 2.4 Regular F 36
General Motors 2.0 Regular F 29
General Motors 2.0 Regular F 27
General Motors 2.0 Regular F 32
General Motors 2.0 Regular F 27
General Motors 2.4 Regular F 36
General Motors 2.4 Regular F 31
General Motors 2.4 Regular F 31
General Motors 1.4 Regular F 38
General Motors 1.4 Regular F 38
General Motors 1.8 Regular F 35
General Motors 1.8 Regular F 36
General Motors 1.4 Regular F 39
General Motors 1.4 Regular F 42
General Motors 2.4 Regular F 33
General Motors 2.4 Regular F 33
General Motors 1.4 Regular F 37
Hyundai 1.8 Regular F 40
Hyundai 1.8 Regular F 40
Hyundai 2.4 Regular F 40
Kia 2.0 Regular F 36
Kia 2.0 Regular F 34
Kia 2.4 Regular F 32
Kia 2.4 Regular F 32
Kia 2.0 Regular F 37
Kia 2.0 Regular F 34
Kia 2.4 Regular F 35
Kia 2.4 Regular F 35
Kia 2.4 Regular F 40
MAZDA 2.0 Regular F 39
MAZDA 2.0 Regular F 38
MAZDA 2.5 Regular F 31
MAZDA 2.5 Regular F 30
MAZDA 2.3 Premium F 25
Nissan 2.5 Regular F 32
Nissan 2.0 Regular F 34
Nissan 2.0 Regular F 31
Nissan 2.5 Regular F 30
Nissan 2.5 Premium F 28
Subaru 2.5 Regular A 31
Subaru 2.5 Regular A 27
Subaru 2.5 Premium A 25
Toyota 2.5 Regular F 35
Toyota 2.5 Regular F 39
Toyota 2.5 Regular F 38
Toyota 1.8 Regular F 48
Audi 3.0 Premium A 28
Audi 3.0 Premium A 28
BMW 3.0 Premium R 31
BMW 3.0 Premium R 30
BMW 3.0 Premium A 30
Chrysler Group LLC 3.6 Regular F 29
Chrysler Group LLC 3.6 Regular F 29
Chrysler Group LLC 3.6 Regular R 27
Ford Motor Company 3.5 Regular F 27
Ford Motor Company 3.0 Regular F 28
Ford Motor Company 3.5 Regular F 27
Ford Motor Company 3.5 Regular A 25
Ford Motor Company 3.0 Regular A 26
Ford Motor Company 3.5 Regular A 25
General Motors 3.6 Regular F 27
General Motors 3.6 Regular F 27
General Motors 3.6 Regular F 26
General Motors 3.6 Regular R 27
General Motors 3.6 Regular R 26
General Motors 3.6 Regular A 26
General Motors 3.0 Regular A 26
General Motors 3.6 Regular A 27
Honda 3.5 Premium F 29
Honda 3.7 Premium A 24
Honda 3.7 Premium A 26
Honda 3.7 Premium A 25
MAZDA 3.7 Regular F 27
Mercedes-Benz 3.5 Premium R 30
Nissan 3.5 Regular F 27
Nissan 3.5 Premium F 26
Nissan 2.5 Premium R 29
Nissan 3.5 Premium R 32
Nissan 2.5 Premium A 27
Nissan 3.7 Premium R 27
Nissan 3.7 Premium R 25
Nissan 3.7 Premium R 26
Nissan 3.7 Premium A 25
Nissan 3.7 Premium A 24
Subaru 3.6 Regular A 25
Toyota 3.5 Regular F 28
Toyota 3.5 Regular F 30
Volkswagen 3.6 Premium F 28
Audi 4.2 Premium A 28
BMW 4.4 Premium R 23
BMW 4.4 Premium R 22
BMW 4.4 Premium R 24
BMW 4.4 Premium A 20
Chrysler Group LLC 6.4 Premium R 23
Chrysler Group LLC 5.7 Premium R 23
Chrysler Group LLC 6.4 Premium R 23
General Motors 6.2 Premium R 18
General Motors 6.2 Premium R 19
Jaguar Cars 5.0 Premium R 21
Jaguar Cars 5.0 Premium R 23
Mercedes-Benz 5.5 Premium R 24
Nissan 5.6 Premium R 24
Nissan 5.6 Premium A 23
Toyota 4.6 Premium R 24
Toyota 4.6 Premium R 24
Toyota 4.6 Premium A 23
Toyota 4.6 Premium A 23
Toyota 5.0 Premium A 23

Solution

Regression Analysis: Hwy MPG versus Displacement, Fuel

The regression equation is
Hwy MPG = 40.6 - 3.19 Displacement - 2.72 Fuel


Predictor Coef SE Coef T P
Constant 40.5946 0.4906 82.74 0.000
Displacement -3.1944 0.1701 -18.77 0.000
Fuel -2.7230 0.4222 -6.45 0.000


S = 3.20680 R-Sq = 68.5% R-Sq(adj) = 68.3%


Analysis of Variance

Source DF SS MS F P
Regression 2 6841.1 3420.5 332.62 0.000
Residual Error 306 3146.8 10.3
Total 308 9987.9


Source DF Seq SS
Displacement 1 6413.3
Fuel 1 427.8


Unusual Observations

Obs Displacement Hwy MPG Fit SE Fit Residual St Resid
34 1.50 44.000 35.803 0.295 8.197 2.57R
35 1.30 44.000 36.442 0.316 7.558 2.37R
36 1.30 44.000 36.442 0.316 7.558 2.37R
64 2.00 25.000 31.483 0.406 -6.483 -2.04R
65 2.00 22.000 31.483 0.406 -9.483 -2.98R
66 2.00 23.000 31.483 0.406 -8.483 -2.67R
75 2.50 23.000 29.886 0.350 -6.886 -2.16R
92 1.50 46.000 35.803 0.295 10.197 3.19R
122 6.20 18.000 20.789 0.670 -2.789 -0.89 X
123 6.20 24.000 20.789 0.670 3.211 1.02 X
124 6.20 24.000 20.789 0.670 3.211 1.02 X
204 2.00 27.000 34.206 0.255 -7.206 -2.25R
206 2.00 27.000 34.206 0.255 -7.206 -2.25R
221 2.40 40.000 32.928 0.240 7.072 2.21R
230 2.40 40.000 32.928 0.240 7.072 2.21R
247 1.80 48.000 34.845 0.268 13.155 4.12R

R denotes an observation with a large standardized residual.
X denotes an observation whose X value gives it large leverage.

Summary of Regression Statistics:

The regression equation is
Hwy MPG = 40.6 - 3.19 Displacement - 2.72 Fuel

Multiple R:0.827647

R Square:68.5%

Adjusted R Square:68.3%

Standard error=10.3

Observations=309

c) the observed value of the test statistic is t=-6.45 and p-value=0<0.05,so we can conclude that the coefficient of the dummy variable Fuel is significantly different from 0.

Coefficients P-Value
Intercept 40.5946 0
Displacement -3.1944 0
Fuel -2.7230 0
b. Consider the addition of the dummy variable FuelPremium, where the value of FuelPremium is 1 if the required or recommended type of fuel is premium gasoline
b. Consider the addition of the dummy variable FuelPremium, where the value of FuelPremium is 1 if the required or recommended type of fuel is premium gasoline
b. Consider the addition of the dummy variable FuelPremium, where the value of FuelPremium is 1 if the required or recommended type of fuel is premium gasoline
b. Consider the addition of the dummy variable FuelPremium, where the value of FuelPremium is 1 if the required or recommended type of fuel is premium gasoline
b. Consider the addition of the dummy variable FuelPremium, where the value of FuelPremium is 1 if the required or recommended type of fuel is premium gasoline
b. Consider the addition of the dummy variable FuelPremium, where the value of FuelPremium is 1 if the required or recommended type of fuel is premium gasoline
b. Consider the addition of the dummy variable FuelPremium, where the value of FuelPremium is 1 if the required or recommended type of fuel is premium gasoline
b. Consider the addition of the dummy variable FuelPremium, where the value of FuelPremium is 1 if the required or recommended type of fuel is premium gasoline

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site