Question

Car engine displacement in liters and fuel consumption for combined city/highway in miles per gallon (MPG).
This data is from 2015 Fuel Economy Guide for the Department of Energy (DOE)
	Engine			a. Make a scatterplot of the car MPG by displacement from the data in columns B and C.
	Displacement	Combined			Be sure the scatterplot contains the 5 important points of a chart or graph.
Car	Liters	MPG
Acura RLX	3.5	22.0		b. Place the regression trend line on the scatterplot.
Audi A6	2.0	28.0
Audi A8	3.0	22.0		c. Find the equation of the regression line for predicting car MPG from displacement in liters.
BMW 525i	3.0	24.0
Buick LaCrosse	3.6	21.0		d. Find the correlation for the data in this scatterplot.
Cadillac CTS	3.6	24.0
Chevrolet Impala	3.6	21.0		e. Find the α = .05 critical value. Is this a valid correlation?
Chevrolet Malibu	2.5	29.0
Dodge Stratus	2.4	26.0		f. You are interested in fuel economy and are looking at car with an engine displacement of 0.698 liters (Smart Car).
Ford Focus	2.0	32.0			What would be the predicted combined MPG for such a car?
Ford Mustang	5.0	21.0			Can we trust this prediction?			Why? Or Why not?
Ford Taurus	3.5	23.0
Honda Accord	3.5	25.0		g. What proportion of the variation in the combined MPG can be explained by the linear relationship
Honda Civic	1.8	33.0			between MPG and engine displacement?
Hyundai Elantra	2.0	28.0
Infiniti Q40	3.7	22.0		h. For every one liter increase in engine displacement how much will the MPG change?
Jaguar XJ8	5.0	20.0
Kia Forte	2.0	29.0
Kia K900	3.8	21.0
Lexus GS350	3.5	23.0
Lexus LS 460	4.6	19.0
Lincoln MKZ	3.7	22.0
Mazda 3	2.5	32.0
Mercedes-Benz E350	3.5	23.0
Mercury Grand Marquis	4.6	21.0
Mitsubishi Lancer	2.4	26.0
Nissan Altima	2.5	31.0
Subaru Legacy	2.5	30.0
Subaru Outback	3.6	22.0
Toyota Avalon	3.5	24.0
Toyota Corolla	1.8	31.0
Volkswagon Passat	3.6	23.0
Volvo S80	3.0	22.0

Answer 1

"Scatter plot Step 1: Select the columns Engine Displacement and Combined MPG. Step 2: Go to insert and select the scatter under Charts. Regression trend line: Step 1: Now select any point on the chart and right click. You will get the window as follows, \r\n Combined MPG Step 2: Select the option ""Add TrendLine"" Step 3: In the newly opened window, select the Linear option \r\n Step 4: Now the chart have the trend line \r\n Finding the equation of the regression trend line: Step 1: Right click on the regression trend line, you have the options as shown below. Step 2: Select the Format TrendLine. Step 3: In the opened new window select the check box ""Display Equation on chart"" and close it \r\n Step 4: Now the equation is displayed on the regression line "