Question

I need assistance with the (a)

An engineer wants to determine how the weight of a gas-powered car, x, affects gas mileage, y. The accompanying data represent the weights of various domestic cars and their miles per gallon in the city for the most recent model year. Complete parts (a) through (d) below. Click here to view the weight and gas mileage data. (a) Find the least-squares regression line treating weight as the explanatory variable and miles per gallon as the response variable. y = x+ | (Round the x coefficient to five decimal places as needed. Round the constant to two decimal places as needed.) © Car Weight and MPG Miles per Gallon, y 17 Weight (pounds), x 3738 3770 2671 3468 3325 2877 3689 2508 3541 3748 3355 Enter your answer in the edit fields and then click Check Answer

Please show details

Answer 1

weight(x)	Miles per Gallon(y)	X - Mx	Y - My	(X - Mx)2	(X - Mx)(Y - My)
3738	17	402.5455	-2.6364	162042.8	-1061.26
3770	17	434.5455	-2.6364	188829.8	-1145.62
2671	25	-664.455	5.3636	441499.8	-3563.89
3468	20	132.5455	0.3636	17568.3	48.1983
3325	20	-10.4545	0.3636	109.2975	-3.8017
2877	23	-458.455	3.3636	210180.6	-1542.07
3689	18	353.5455	-1.6364	124994.4	-578.529
2508	23	-827.455	3.3636	684681	-2783.26
3541	18	205.5455	-1.6364	42248.93	-336.347
3748	18	412.5455	-1.6364	170193.8	-675.074
3355	17	19.5455	-2.6364	382.0248	-51.5289

Sum of X = 36690
Sum of Y = 216
Mean X (M_X) = 3335.4545
Mean Y (M_y) = 19.6364
Sum of squares (SS_X) = 2042730.7273
Sum of products (SP) = -11693.1818

Regression Equation = ŷ = bX + a

b = SP/SS_X = -11693.18/2042730.73 = -0.00572

a = M_Y - bM_X = 19.64 - (-0.01*3335.45) = 38.72947

ŷ = -0.00572X + 38.73