Question

FIRST TECHNOLOGY PROJECT: It is recommended that you use MS Excel. This project reviews the concepts covered in Chapter 14, when correlation between two characteristics is determined.

Car Weight and Fuel Consumption:

Given are weights (in pounds) and highway fuel consumption amounts (in mi/gal) of

7 randomly selected cars.

Car Weights 3175 3450 3225 3985 2440 2500 2290 Fuel Consumption 27 29 27 24 37 34 37

Show proof of your answer to the following questions:

a. Is there a correlation between weight and highway fuel consumption? Proof of your answer must be quantitative and verifiable. Your opinion is not enough evidence.

b. What does result suggest about a national program to reduce the consumption of imported oil?

  

Answer 1

go to excel, write the two columns, insert a scatter chart. in chart options, go to trendline, and select R^2 option.

a) yes, the R-squared value is 0.891 which suggests a strong relation between car weights and fuel consumption.

b) we have observed that there is a significant relationship between car weight and fuel consumption. This relation is inversely related, i.e. if car weight increases, fuel consumption decreases and vice-versa. This can be seen from the excel graph. Thus, the national program can promote the sale and use of heavier cars (cars with more weight) so as to reduce fuel (oil) consumption.