Question

Estimate the multiple linear regression equation     for the given data   

	1              2              3               4
	10             1              2               3
	12            18            24             30

1. 
   

Estimate the multiple linear regression equation y with overparenthesis on top equals b subscript 0 plus b subscript 1 x subscript 1 plus b subscript 2 x subscript 2 for the given data

x subscript 1

1 2 3 4

x subscript 2

10 1 2 3

y

12 18 24 30

Answer 1

Ans)

To estimate we use excel data solver

1) click on Data tab

2) click on Data Analysis

3) click on regression

4) select y range

5) select x range

6) click ok

From last,

we can see Intercept = 6

x1 = 6

x2 ~ 0

so, equation is

For calculation by hand