Exhibit 134 Below you are given a partial Excel output based

Exhibit 13-4
Below you are given a partial Excel output based on a sample of 16 observations.

ANOVA

df

SS

MS

F

Regression

4,853

2,426.5

Residual

485.3

Coefficients

Standard Error

Intercept

12.924

4.425

x₁

-3.682

2.630

x₂

45.216

12.560

Refer to Exhibit 13-4. The estimated regression equation is

E(y) = ₀ + ₁x₁ + ₂x₂

Solution

The estimated regression equation is

E(y)=12.924-3.682 x1+45.216 x2

here we obtain the regreesion equation from the table of anova-> Coefficients