Computing regression equation using multiple regression models.
Using multiple linear regressions, compute the regression equation for the following data in Excel.
|
Y
|
X1
|
X2
|
|
14.3
|
8.1
|
7.2
|
|
13.2
|
7.8
|
6.4
|
|
14.2
|
8.6
|
7.1
|
|
12.5
|
7.6
|
6.1
|
|
14
|
8.4
|
7.5
|
|
12.6
|
7.7
|
6.3
|
|
14.9
|
9
|
7.7
|
|
13.4
|
7.9
|
6.4
|
|
13.6
|
9.1
|
7.8
|
|
14.8
|
8.3
|
7.5
|
|
13.7
|
8.4
|
6.6
|
|
15.4
|
7.9
|
7.9
|
|
14.8
|
8.2
|
7.4
|
|
12.9
|
7.5
|
6.2
|
|
14.2
|
8.5
|
7
|
|
13
|
7.6
|
6.5
|
|
15.1
|
8.8
|
7.8
|
|
14.2
|
8.2
|
7.2
|
|
13.2
|
7.1
|
6.5
|
|
15
|
7.4
|
8
|