Please Use Excel !
1. In a regression analysis involving 30 observations, the following estimated regression equation was obtained.
y estimate = 17.6 + 3.8x1 - 2.3x2 + 7.6x3 + 2.7x4
a) Interpret b1, b2, b3, and b4 in this estimated regression equation.
b) Estimate y when x1 = 9, x2 = 4, x3 = 2, and x4 = 3.