The table below shows the Excel output for a multiple regression model for 8 obs

Question

The table below shows the Excel output for a multiple regression model for 8 observations of two independent variables. Write the multiple regression equation for the relationship between the dependent variable y and the independent variables x_1 and x_2: A) y = 30 + 16x B) y = 83.23 + 2.29x + 1.30x_2 C) y = 50 + 2.29x_1 + 12.6x_2. Which of the following statements is true: A) The value of the y variable is increasing by 2.29 for each unit increase in variable x_2. - B) The value of the y variable is decreasing by 1.30 for each unit increase in variable x_2. C) The value of the y variable is increasing by 2.29 for each unit increase in variable x_1. - D) The value of the y variable is increasing by 50 for each unit increase in the intercept. The multiple coefficient of determination is: A) 0.87 B) 0.76 C) 0.99 D) 0.92 The adjusted multiple coefficient of determination is: A) 0.89 B) 0.95 C) 0.76 D) 0.99 The predicted value of y when x_1 = 10and x_2 = 2 is:

Explanation / Answer

Answer to the question below:

1.

Take a look at the last table' coefficients.

The answer is : B) 83.23+2.29x1+1.30x2

2. C is the right interpretation

3. Rsquare = SSr/SSt = 23.44/25.5 = .92

4.

Adj. R2 = 1-(1-Rsqaure)(N-1)/(N-p-1)

Now, adj = 1- (1-.92)(8-1)/(8-2-1) = .89

Answer is A

4.

Predicted value of y when x1=10 and x2=2 is :

83.23+2.29*10+1.3*2= 108.73

Answer is B

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.