Regression Line car problem

Question

The data set below gives the greenhouse emissions and fuel economy for five car models

Car Model City MPG Greenhouse Emissions

A 21 8.0

B 11 14.1

C 19 8.7

D 16 9.6

E 24 6.8

Calculate the regression line and correlation coefficient. Use city MPG as the independent variable. Round your answer to 2 decimal places

Regression line: y = Answer(x) + Answer

Correlation Coefficient = Answer

Answer 1

The slope and intercept are

The R-coefficient is

The linear equation for the Best Fit trend line is Y = -0.54494X + 19.35789;

The R-coefficient is close to -1, so this is a good fit !!!

here's the table:

X Y X^2 XY Y^2 Line Estimate Error

21 8 441 168 64 7.91417004 0.08582996

11 14.1 121 155.1 198.81 13.36356275 0.736437247

19 8.7 361 165.3 75.69 9.004048583 -0.304048583

16 9.6 256 153.6 92.16 10.6388664 -1.038866397

24 6.8 576 163.2 46.24 6.279352227 0.520647773

-----------------------------------------------------------------------------------------------

91 47.2 1755 805.2 476.9 47.2 0

N 5

D 494 R-coefficient

-0.967681682

M -0.544939271

B 19.35789474