Question

Subject #	Honesty	Satisfaction
1	5	9
2	3	2
3	7	10
4	2	6
5	4	4
6	6	7

1)Given the data illustrated in the table above, compute the equation for the linear regression line (i.e. y = mx+b) (7--pts)

2)Based on the regression line you computed, what is the likely level of satisfaction if a person were to have an honesty level

a.2.5

b.8?

c.3.5?

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
1) Regression equation is ,

y=1.1429x+1.1905

2) Substitute given values of x in regression equation and solve it.

a) For x=2.5 then y= 1.1429(2.5)+1.1905

=4.05

b) For x=8 , then y= 1.1429(8)+1.1905

=10.33

c) For x=3.5 then  y= 1.1429(3.5)+1.1905

=5.19