The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for car trucks (U.S. Department of Energy website, February 22, 2008). A portion of the data for compact, midsize, and large cars follows. The column labeled Class identifies the size of t 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 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 DATAfile named FuelData. Click on the datafile logo to reference the data. DATA file (a) Develop an estimated regression equation that can be used to predict the fuel efficier for highway driving, given the engine's displacement. Let x represent the engine's displacement. If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: 300 y^= Is there a relationship between HwyMPG and displacement at the 0.05 level of significance? How much of the variation in the sample values of HwyMPG is is explained by this estimated regression equation? If required, round your answer to one decimal places. (3) (b) Create a scatter chart in Excel with HwyMPG on the y-axis and displacement on the x for which the points representing compact, midsize, and large automobiles are showr different shapes and or colors. Choose the correct chart below. (i) The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for car trucks (U.S. Department of Energy website, February 22, 2008). A portion of the data for compact, midsize, and large cars follows. The column labeled Class identifies the size of t 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 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 DATAfile named FuelData. Click on the datafile logo to reference the data. DATA file (a) Develop an estimated regression equation that can be used to predict the fuel efficier for highway driving, given the engine's displacement. Let x represent the engine's displacement. If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: 300 y^= Is there a relationship between HwyMPG and displacement at the 0.05 level of significance? How much of the variation in the sample values of HwyMPG is is explained by this estimated regression equation? If required, round your answer to one decimal places. (3) (b) Create a scatter chart in Excel with HwyMPG on the y-axis and displacement on the x for which the points representing compact, midsize, and large automobiles are showr different shapes and or colors. Choose the correct chart below. (i)
