(a)
| variables | VIF |
| Intercept | |
| Horsepower | 3.186 |
| Weight | 3.257 |
| Transmission | 1.084 |
(b) Since all the VIF's are less than 5, none of the independent variables are related to each other.
(c) No, since all the VIF's are less than 5.
(d) No
(e) No
The data is:
| MPG | Horsepower | Weight | Transmission |
| 43.1 | 48 | 1685 | manual |
| 19.9 | 110 | 3365 | manual |
| 19.2 | 105 | 3535 | manual |
| 17.7 | 165 | 3445 | manual |
| 18.1 | 139 | 3205 | manual |
| 20.3 | 103 | 2830 | manual |
| 21.5 | 115 | 3345 | automatic |
| 16.9 | 155 | 4360 | automatic |
| 15.5 | 142 | 4054 | automatic |
| 18.5 | 150 | 3940 | automatic |
| 27.2 | 71 | 2190 | automatic |
| 41.5 | 76 | 2044 | automatic |
| 46.6 | 65 | 2110 | automatic |
| 23.7 | 100 | 2420 | automatic |
| 27.2 | 84 | 2490 | automatic |
| 39.1 | 58 | 1455 | automatic |
| 28 | 88 | 2305 | automatic |
| 24 | 92 | 2465 | automatic |
| 20.2 | 139 | 3570 | automatic |
| 20.5 | 110 | 3155 | manual |
| 28 | 90 | 2678 | manual |
| 34.7 | 63 | 2015 | manual |
| 36.1 | 66 | 1800 | manual |
| 35.7 | 80 | 2015 | manual |
| 20.2 | 85 | 2965 | manual |
| 23.9 | 90 | 2920 | manual |
| 29.9 | 65 | 2380 | manual |
| 30.4 | 67 | 2850 | automatic |
| 36 | 74 | 1980 | automatic |
| 22.6 | 110 | 2800 | automatic |
| 36.4 | 87 | 2950 | automatic |
| 27.5 | 95 | 2560 | automatic |
| 33.7 | 75 | 1910 | automatic |
| 44.6 | 67 | 1850 | automatic |
| 32.9 | 100 | 2615 | automatic |
| 38 | 67 | 1963 | automatic |
| 24.2 | 120 | 3230 | automatic |
| 38.1 | 60 | 1968 | automatic |
| 39.4 | 70 | 2070 | automatic |
| 25.4 | 116 | 2985 | automatic |
| 31.3 | 75 | 1842 | automatic |
| 34.1 | 68 | 1985 | automatic |
| 34 | 88 | 2395 | automatic |
| 31 | 82 | 2720 | automatic |
| 27.4 | 80 | 2470 | manual |
| 22.3 | 88 | 2890 | manual |
| 28 | 79 | 2025 | manual |
| 17.6 | 85 | 3465 | manual |
| 34.4 | 65 | 3465 | manual |
| 20.6 | 105 | 3380 | manual |
a.Calculate and present the variance inflation factor, VIF, for each predictor variable. b.Based on VIF, which,...
a.Present (here) the plot of the residuals of this simple
linear regression model against its fitted values.
b. Describe (here) the appearance of this residual
plot.
c.State (here) the RMSE of this regression.
MPG 43.1 19.9 19.2 Horsepower 48 110 105 165 139 103 115 155 142 150 71 76 65 100 84 58 88 92 139 110 90 17.7 18.1 20.3 21.5 16.9 ISS 185 27.2 41.5 46.6 23.7 27.2 39.1 28.0 24.0 20.2 20.5 28.0 34.7 36.1 35.7...
Perform simple linear regression model for gasoline mileage as
it depends on horsepower alone. Present a copy of this regression
output report.
a.State (here) this simple linear regression equation.
b.Overall, is this regression significant? Choose yes or no
and explain the reason for your choice.
c.Comment on the significance of the variable
coefficient.
d.How much of the variation in mpg is fairly represented by
this model?
MPG 43.1 19.9 19.2 Horsepower 48 110 105 165 139 103 115 155 142...
Perform another multiple regression model for gasoline mileage
as it depends on the set of independent variables retained from
part 12.e (use the same definitions of the variables as you used in
part 1).
• Present a copy of this regression output report.
a.State (here) this multiple regression equation.
b.Overall, is this regression significant?
c.Comment on the significance of each individual variable
coefficient.
d.How much of the variation in mpg is fairly represented by
this model?
a.Present the plot of...
a.Predict the gasoline mileage for a vehicle that has a 105
horsepower engine, weighs 3380 pounds, and has a manual
transmission.
b.What is the residual in gasoline mileage between the mpg
calculated in part 9.a and the actual gasoline mileage for this
vehicle as listed in the data table?
c.State two reasons why the result calculated in part 9.a is
different from the actual gasoline mileage for this vehicle as
listed in the data table.
Transmission manual MPG 43.1 19.9...
An
analyst at a consumer organization must develop a regression model
to predict fuel economy (also referred to as gasoline mileage) of
automobiles measured in miles per gallon (mpg) based on the
horsepower of its engine, the weight of the car (in pounds) and the
type of transmission (manual or automatic). The data for 50
randomly selected automobiles is presented in the table below. Fit
a multiple regression model for gasoline mileage as it depends on
engine horsepower, vehicle weight,...
a.Overall, is this regression significant? Yes or no?
Explain, including the specific statistic or statistics that were
used and how they were used.
b.Is each individual variable coefficient significant? Yes
or no for each variable. Explain for each variable, including the
specific statistic or statistics that were used and how they were
used.
7.a.State (here) the value of the coefficient of
determination for this model.
b.Show (here) that this coefficient is numerically equal to
SSR/SST.
c.State (here) the value of...
a.State
(here)
in words
the specific
meaning of
the numerical
value of the regression
coefficient on engine
horsepower in terms of
what it measuresfor this
problem.
Does this
coefficient make sense, according to what you would expect for
it?
b.State
(here)
in words
the specific
meaning of
the numerical
value of the regression
coefficient on
weight in terms of
what it measures for this
problem.
(In other
words, what does this number measure and how much?)
• Does this
coefficient...
Use excels data analysis tool to preform a regression on the following set on numbers. Post your results. Then answer the following questions. A consumer Organization want to develop a regression model to predict gasoline mileage (as measured by miles per gallon) based on horsepower of the car's engine and the weight of the car, in pounds. A sample of 50 percent recent car models was selected, with the results recorded. 1. State the multiple regression equation. 2. Interpret the...