Question

Here is a bivariate data set. Find the regression equation for the response variable y.

x	y
26.7	-82
59.8	204.5
58.3	68.3
56.4	124.3
21.1	18.8
33.1	59.9
15.2	-31.8
37	12.8
36.8	-48
53.8	17.4
53.1	88.4
60.2	100
35.6	30
51.4	62.5

Answer 1

We can directly use here Excel for regression,

Step1) Enter data in Excel.

Step 2) Data >>data analysis >>Regression >> select x and y values separately >>ok

We have regression equation for response variable y is,