X1	X2	Y
30	12	94
47	10	108
25	17	112
51	16	178
40	5	94
51	19	175
74	7	170
36	12	117
59	13	142
76	16	211

Copy and paste the data in the table below into Excel and estimate the model

y^=b0+b1x1

1. What is the value of y^ if x1 = 47? Round to four decimal places.

Note: The regression has only one independent variable even though the table includes x1 and x2.

Copy and paste the data in the table below into Excel and estimate the model

y^=b0+b2x2 (Same table)

2. What is the value of y^ if x2 = 10? Round to four decimal places.

Copy and paste the data in the table below into Excel and estimate the model

y^=b0+b1x1+b2x2 (same table above)

3. What is the value of y^ if x1=47 and x2 = 10? Round to four decimal places.

Note: this is the same data used in the previous question.

4. Which parameters are statistically significant at the 5% level, =0.05 ? a. b1, b2

b. b0, b1, b2

c. b0, b1

d. b0, b2

e. b1

f. b2