Is the estimate of the coefficient on the gasoline dummy

Question

Part (a)  Run a multiple regressionthat has the maintenance cost as the dependent variable and the age, miles per month, and Gasoline dummy variable as independent variables.
You must either submit a screen shot of your output or your actual Excel file with the output as part of the assignment.

Part (b)  Interpret the estimated value of the coefficient on "Age," i.e., explain what the number means in this regression.

Part (c)  Interpret the estimated value of the coefficient on "Miles per month," i.e., explain what the number means in this regression.

Part (d)  Interpret the estimated value of the coefficient on the "Gasoline" dummy, i.e., explain what the number means in this regression.

Part (e)  Is the estimate of the coefficient on the "Gasoline" dummy statistically significant? Please answer "yes" or "no" and explain how you can tell.

Part (f)  Is the estimate of the coefficient on the "Gasoline" dummy of practical significance? Please answer "yes" or "no" and explain how you can tell.
(Hint: You will need to discuss the impact of the engine type on the dollar amount spent on maintenance and state your opinion on whether it is large enough to matter.)

Part (g)  Now suppose that we created a dummy variable for Diesel engines, i.e., the new dummy would have a value of 0 whenever the Gasoline dummy is 1, and it would have a value of 1 whenever the Gasoline dummy is 0. If instead of the regression in part (a) we ran a regression that has the maintenance cost as the dependent variable and the age, miles per month, and the Diesel dummy as independent variables, what would be the coefficient (slope) estimate on the Diesel dummy? Why?

Part (h)  What is the predicted maintenance cost for a 6-year-old bus with a gasoline engine that gets driven for 900 miles per month?

Part (i)  What is the predicted maintenance cost for a 10-year-old bus with a Diesel engine that gets driven for 800 miles per month?

Part (j)  Name one other variable that is not included in the data set that you think would be useful as an additional independent variable. Then state whether you think that the additional regressor would have a positive or a negative impact on the maintenance cost and explain your answer.

Attachment:- bus_maintenance1.xls

Answer 1

You have to submit the following assignment which is require to run on the desktop that shows your all consequence Part (a) Run a multiple regression that has the maintenance cost as the dependent variable and the age, miles per month, and Gasoline dummy variable as independent variables. You must either submit a screen shot of your output or your actual Excel file through the output as part of the assignment. Part (b) Interpret the approximated value of the coefficient on "Age," for example, illustrate what the no means in this regression. Part (c) Interpret the estimated value of the coefficient on "Miles per month," for example, explain what the number means in this regression. Part (d) Interpret the estimated value of the coefficient on the "Gasoline" dummy, for example, describe what the no means in this regression.