d Consider the addition of the dummy variables FrontWheel an

d. Consider the addition of the dummy variables FrontWheel and RearWheel. The value of FrontWheel is 1 if the car has front wheel drive and 0 otherwise; the value of RearWheel is 1 if the car has rear wheel drive and 0 otherwise. Thus, for an a car that has all wheel drive, the value of FrontWheel and the value of RearWheel is 0. Develop the estimated regression equation that can be used to predict the fuel efficiency for highway driving given the engine\'s displacement, the dummy variable FuelPremium, and the dummy variables FrontWheel and RearWheel.

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

e. For the estimated regression equation developed in part (d), test for overall significance and individual significance using = .05.
p-value is

Solution

I am unable to paste the modified data as chegg doesn\'t allow to write the answer in more than 65,000 words.

But I am providing the solution.

However, you can use the \'Replace\' option from the \'Home\' tab to edit the data.

Then you can apply the multiple linear regression using the \'Data Analysis\' add-in considering the Hwy MPG as the dependent and the others as independent variables. You will get the following output -

e)

The F-test of the overall significance of the regression has the p-value of 1.548 x 10^-85 which is approximately zero. So, we would reject the null hypothesis and conclude that the regression is significant with at least one of the coefficients being significantly different from 0.

The p-values of the test statistic for the individual coefficients are also very small (tending to 0) which again indicates the rejection of null hypothesis and hence we would conclude that all the variables are significant at 0.05 level.