Question

Compute the least-squares regression equation for the given data set. Round the slope and y -intercept to at least four decimal places. x 5 4 2 6 3 y 4 5 1 3 6 Send data to Excel Regression line equation: = y

Answer 1

We can use here Excel for regression equation

Step 1) Enter data in Excel .

Step 2) Data >>Data analysis >>Regression >>Select y and x values separately >>Ok
Therefore, linear regression equation is,

y=0.2x + 3