Homework Answers
1.
Mpg =50.2146 -0. 2367* horsepower
b. F significance = 0.000 < 0.05
Thus the overall regression is significant.
c. The p value for test of significance of regression is 0.00001 which is less than 0.05 thus there is significant relationship betweenbetween mpg and horsepower.
d. The coefficient of determination is 0.6198 thus 61.98% variation in the mpg is explained by the regression equation.
I have given my best to solve your problem. Please like the answer if you are satisfied with it. ?
Add Answer to:
Perform simple linear regression model for gasoline mileage as
it depends on horsepower alone. Present a...
Perform another multiple regression model for gasoline mileage as it depends on the set of independent...
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.Present (here) the plot of the residuals of this simple linear regression model against its fitted...
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...
a.Predict the gasoline mileage for a vehicle that has a 105 horsepower engine, weighs 3380 pounds,...
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...
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.Calculate and present the variance inflation factor, VIF, for each predictor variable. b.Based on VIF, which,...
a.Calculate and present the variance inflation factor, VIF,
for each predictor variable.
b.Based on VIF, which, if any, of any of the independent
variables are related to each other such an extent that you suspect
that they are not truly independent of each other. Why?
c.Based on VIF, is multicollinearity a problem? Briefly
explain why?
d.If your answer to part 12.c is “yes,” do you recommend
deleting any of the predictor variables?
e.If your answer to part 12.d is “yes,”...
a.Overall, is this regression significant? Yes or no? Explain, including the specific statistic or statistics that...
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...
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...
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...
9. a. Predict the gasoline mileage for a vehicle that has a 105 horsepower engine, weighs...
9. a. Predict the gasoline mileage for a vehicle that has a 105
horsepower engine, weighs 3380 pounds, and has a manual
transmission.
Manual: MPG (Y) = 51.77 - 0.1437 Horsepower (X1) - 0.00460
Weight (X2)
= 51.77-0.1437(105)-0.00460(3380) = 21.133
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...
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.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...
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.Calculate and present the variance inflation factor, VIF,
for each predictor variable.
b.Based on VIF, which, if any, of any of the independent
variables are related to each other such an extent that you suspect
that they are not truly independent of each other. Why?
c.Based on VIF, is multicollinearity a problem? Briefly
explain why?
d.If your answer to part 12.c is “yes,” do you recommend
deleting any of the predictor variables?
e.If your answer to part 12.d is “yes,”...
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...
9. a. Predict the gasoline mileage for a vehicle that has a 105
horsepower engine, weighs 3380 pounds, and has a manual
transmission.
Manual: MPG (Y) = 51.77 - 0.1437 Horsepower (X1) - 0.00460
Weight (X2)
= 51.77-0.1437(105)-0.00460(3380) = 21.133
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...
Most questions answered within 3 hours.
-
Circular distribution
•Suppose two birds are flying, one is flying from the north and
the other...
asked 1 minute from now -
If tcalc = -2.78, tcrit = 1.96, H0: Mu > Mu0, and Xbar <
Mu0, what...
asked 36 seconds from now -
Write a program that reads a floating point number and prints
“zero” if the number is...
asked 51 seconds ago -
Geoff has been running a restaurant in the city for many years.
He knows from experience...
asked 10 minutes ago -
NaOH is added to a buffer solution composed of C6H5COOH and
C6H5COO―. Which of the following...
asked 2 minutes ago -
please answer all... it all counts as a discussion problem
1a qualitative data and proportions: Suppose...
asked 2 minutes ago -
Program: Write a complete C++ program that is
made of functions main() and rShift(). The rShift()...
asked 10 minutes ago -
Extended exposure can cause hearing loss. Is this
sensorineural hearing loss or conduction hearing loss? Explain....
asked 19 minutes ago -
a
conducting spherical shell of inner radius a and outer radius b has
a point charge...
asked 19 minutes ago -
If a family spends its entire budget in a given time frame, the
family can afford...
asked 20 minutes ago -
Q. A buffer solution prepared by mixing 50.00 mL of 0.200 M
acetic acid and 50.00...
asked 35 minutes ago -
PLEASE DO BOTH OF THESE IN PYTHON!!! AND MAKE SURE THAT
I CAN COPY THE CODE....
asked 34 minutes ago