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.
Get Answers For Free
Most questions answered within 1 hours.