Compute the least-squares regression line for the given data set. X 5.7 4.1 6.2 4.4 6.5 5.8 4.9 y 1.9 4.8 0.8 3.9 1.2 1.7 3.0 I y xy 5.7 1.9 10.83 32.49 4.1 6.2 124569 464 4.8 19.68 16.81 0.8 4.96 38.44 4.4 3.9 17.16 19.36 6.5 1.2 7.8 42.25 5.6 1.7 9.86 33.64 4.9 3.0 14.70 24.01 Find the sum of every column. x = 37.6, =, 17.3, = 84.99, = 207 y = mx + b nxy-xy m= x2 - (13)2 7(84.99)-(37.6) (17.3) 7(207)-(37.6) 594-93-650.48 1449-1413.76 -55.55 35.24 -1.576 y-mxx 17.3 (-1.5763371) (37.6) b = 10.9386107| n 7 y=mx+b Solution y2 = -1.57633x + 10.9386 m in Excel format