Consider the following sample data: y46 52 31 60 21 61 45 56 41 43 2860326848 37
ID: 3307248 • Letter: C
Question
Consider the following sample data: y46 52 31 60 21 61 45 56 41 43 2860326848 37 x21219 19 17 28 29 25 13 a-1. Estimate a multiple linear regression model. (Nogative values should be indicated by a minus sign. Round your answers to 2 decimal places.) y-hat x1 a-2. Interpret its coefficients x1. O As x1 increases by one unit, y is predicted to increase by 0.96 units, holding x2 constant O As x1 increases by one unit, y is predicted to decrease by 0.96 units, holding x2 constant. O As x1 increases by one unit, y is predicted to decrease by 27.53 units, holdng x2 constant. O As xi increases by one unit, y is predicted to increase by 27.53 units, holding x2 constant a-3. Interpret its coofficients x2. O As x2 increases by one unit, y is predicted to increase by 1.19 units, holding x1 oonstant. 0 As x2 increases by one unit y is predicted to increase by 27 53 units, holding x1 constant. 0 As x2 inoeases by one unit, y is predicted to decrease by 1.19 units. holding x1 constant. O As rz inoreases by one unit, y is predicted to decrease by 27 63 units,holding 1 constant b. Find the predicted value for y if xs equals 30 and x2 equals 10. (Round the intermediate calculations and final answer to 2 decimal places.)Explanation / Answer
a-1) from above given data with excel regression function:
yhat= 27.53+0.96 x1 + (-1.19) x2
a-2)
as x1 increases by one unit ; yis predicted to increase by 0.96 units; holding x2 constant.
a-3) as x2 increases by one unit y is predicted to decrease by 1.19 units holding x1 constant
b)
predicted value of y =27.53+0.96*30-1.19*10 =44.43
( Note : exact predicted value is 44.57)
please revert for an clarification required