Question

Use the given data to find the equation of the regression line. x 4 2 4 3 2 y 5 2 3 3 negative 1 ModifyingAbove y with caretequals nothingplus nothingx​ (Round to two decimal places as​ needed.)

Answer 1

We can use here Scatter plot by Excel.
Step1) Enter data in Excel.

Step 2) Select data >>click on insert tab >>Select scatter plot >>Select scatter plot with function.
or

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, we have regression equation is,

y = -2.85 +1.75 x