Consider the following sample data Click here for the Excel Data File y 6442 50

Question

Consider the following sample data Click here for the Excel Data File y 6442 50 51 41 50 43 30 X1 8 7 6 12 13 10 13 x2 2926 28 37 21 26 32 33 a-1. Estimate a multiple linear regression model. (Round your answers to 2 decimal places.) y-hat = a-2. Interpret the coefficient for x2- As x2 increases by one unit, y is predicted to decrease by 2.91 units, holding x constant. As x2 increases by one unit, y is predicted to decrease by 0.74 units, holding x1 constant As x2 increases by one unit, y is predicted to increase by 2.91 units, holding x1 constant As x2 increases by one unit, y is predicted to increase by 0.74 units, holding x1 constant b. Find the predicted value for y if x1 equals 15 and x2 equals 17. (Round your intermediate calculations and final answer to 2 decimal places.) y-hat

Explanation / Answer

Solution

(a1) Using excel :

Intercept = 97.12

Beta 1= -2.91

Betab 2 = -0.74

y = 97.12 -2.91x1 - 0.74x2

(a2) As x2 increases by one unit y is prediced to decrease by 0.74 units, holding x1 constant

(b) Now, x1= 15 and x2 = 17

y = 97.12 - 2.91*15-0.74*17 = 70.89

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---