Question

The exercise involving data in this and subsequent sections were designed to be solved using Excel.

Answer 1

Answer:

Step-by-step explanation:

Hello!

You have two regression models:

The multiple regression model that was estimated is y=40.7+ 8.63x1+ 2.71x2

The Simple regression model that was estimated is y=42.0+9.01x1

a.

MRmodel the 8.63 represents the modification in the estimated mean of Y when X₁ increases one unit and X₂ remains constant.

SRmodel the 9.01 represents the modification in the estimated average of Y when X₁ increases one unit.

b.

Yes, since both variables X₁ and X₂ are correlated, the effect that X₁ has over Y is directly affected by the precence of X₂

I hope you have a nice day!