Please see attachment for excel file. Thanks in advance!

Problem 4-15

The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks (U.S. Department of Energy website, February 22, 2008). A portion of the data for 311 compact, midsize, and large cars follows. The column labeled Class identifies the size of the car; Compact, Midsize, or Large. The column labeled Displacement shows the engine's displacement in liters. The column labeled Fuel Type shows whether the car uses premium (P) or regular (R) fuel, and the column labeled HwyMPG shows the fuel efficiency rating for highway driving in terms of miles per gallon. The complete data set is contained in the file namedFuelData.

Click on the webfile logo to reference the data.

(a)	Develop an estimated regression equation that can be used to predict the fuel efficiency for highway driving, given the engine's displacement.
Letxrepresent the engine's displacement.
If required, round your answers to four decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)
	=+x
Is there a relationship between HwyMPG and displacement at the 0.05 level of significance?
Yes- Select your answer -YesNoItem 3
How much of the variation in the sample values of HwyMPG does this estimated regression equation explain?
If required, round your answer to two decimal places.
%