Consider the following sample data y 46 52 31 60 21 61 45 56

Consider the following sample data:

y 46 52 31 60 21 61 45 56

x1 41 43 28 60 32 68 48 37

x2 12 19 19 17 28 29 25 13

Click here for the Excel Data File

a-1. Estimate a multiple linear regression model. (Negative values should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.)

y-hat = ?+ ?x1 + ?x2

a-2. Interpret its coefficients x1.

A. As x1 increases by one unit, y is predicted to decrease by 27.53 units, holding x2 constant.

B. As x1 increases by one unit, y is predicted to increase by 0.96 units, holding x2 constant.

C. As x1 increases by one unit, y is predicted to increase by 27.53 units, holding x2 constant.

D. As x1 increases by one unit, y is predicted to decrease by 0.96 units, holding x2 constant.

a-3. Interpret its coefficients x2.

A. As x2 increases by one unit, y is predicted to decrease by 1.19 units, holding x1 constant.

B. As x2 increases by one unit, y is predicted to increase by 1.19 units, holding x1 constant.

C. As x2 increases by one unit, y is predicted to increase by 27.53 units, holding x1 constant.

D. As x2 increases by one unit, y is predicted to decrease by 27.53 units, holding x1 constant.

Solution

Using technology, we get the following results:

Thus,

a-1.

Thus,

yhat = 27.53 + 0.96 x1 - 1.19 x2 [ANSWER]

***********************

a-2.

B. As x1 increases by one unit, y is predicted to increase by 0.96 units, holding x2 constant. [ANSWER]

**********************

a-3.

A. As x2 increases by one unit, y is predicted to decrease by 1.19 units, holding x1 constant. [ANSWER]