Question

A data set is given below. ​(a) Draw a scatter diagram. Comment on the type of relation that appears to exist between x and y. ​(b) Given that x̅ = 3.6667, sx = 2.0656​, ŷ = 4.2000​, sy = 1.4805, and r = −0.9287​, determine the​ least-squares regression line. ​(c) Graph the​ least-squares regression line on the scatter diagram drawn in part​ (a).

x   y
1   5.2
2   5.8
3   5.4
4   3.8
6   2.4
6   2.6

​(a) Choose the correct graph below.

Graph B

There appears to be a linear, negative relationship.

​(b)

ŷ =__?__x+(__?__)

​(Round to three decimal places as​ needed.)

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

and

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

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

Therefore, regression equation is,

There appears to be negative relationship.