write my assignment 17480

 The U.S. government has been interested in pushing auto manufacturers to increase the MPG of their fleet.

Based on the regression results, what is the best answer concerning average MPG for 4 cylinder SUVs.

1. 4 cylinder SUVs have statistically higher average MPG when compared to 8 cylinder SUVs.
2. The number of cylinders does not help explain average MPG.
3. 6 cylinder SUVs do not have statistically higher average MPG when compared to 8 cylinder SUVs.
4. 4 cylinder SUVs have statistically higher average MPG when compared to 6 cylinder SUVs.

. MPGavgA weighted average of miles per gallon, 60% highway and 40% city. MPGcityThe estimated miles per gallon for city drivingMPGhwyThe estimated miles per gallon for city drivingEng SizeThe size of the engine in litersCyl_4DumA dummy variable coded as one if the engine is 4 cylinders, zero for 6 or 8 cylinder SUVsCyl_6DumA dummy variable coded as one if the engine is 6 cylinders, zero for 4 or 8 cylinder SUVs. Cyl_8DumA dummy variable coded as one if the engine is 8 cylinders, zero for 4 or 6 cylinder SUVsThe following is the dummy variable regression results of MPGavg on Cyl_4Dum and Cyl_6Dum.Summary of FitRSquare0.7507RSquare Adj0.7456Root Mean SquareError1.7024Mean of Response21.2300Observations (orSum Wgts)100Analysis of VarianceSourceDFSum ofMeanSquaresSquareF RatioModel2846.5858423.293 146.0543Error97281.12422.898 Prob > F<.0001C. Total991127.7100Parameter EstimatesTermEstimateStd Errort Ratio Prob>/t|Intercept 16.95450.36346.7126<.0001Cyl_4Dum 7.24550.442916.36<.0001Cyl_6Dum 3.07580.46866.5641<.0001