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.

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 3 minutes ago

asked 5 minutes ago

asked 6 minutes ago

asked 6 minutes ago

asked 9 minutes ago

asked 14 minutes ago

asked 15 minutes ago

asked 20 minutes ago

asked 35 minutes ago

asked 53 minutes ago

asked 56 minutes ago