Question

Weight	Fuel
	Efficiency
2670	26
2510	28
2680	29
2790	38
3000	25
3410	25
3640	21
3700	27
3880	21
3900	18
4060	21
4710	16

What percent of the variation in fuel efficiency is explained by the variation in weight of the vehicles using the regression line?

Answer 1

We can use here Scatter plot by Excel.
Step1) Enter data in Excel.

Step 2) Select data >>click on insert tab >>Select scatter plot >>Select scatter plot with function.

R-square value is= 0.611

61.1 % of the variation in fuel efficiency is explained by the variation in weight of the vehicles using the regression line