Question: This is one problem. Please state all the formulas as well. A sample of 20 observation is collected. A linear regression model has been developed

This is one problem. Please state all the

This is one problem. Please state all the formulas as well.

A sample of 20 observation is collected. A linear regression model has been developed to predict Y, using X1, X2, X3 as independent variables. The regression output is present below. The regression output is present below. SUMMARY OUTPUT Regression Statistics Multiple R 0.933 R Square (h) Adjusted R Square (0) Standard Error 23.244 Observations 20 ANOVA SS F df (a) Regression Residual Total (f) MS (d) (e) (c) 8644.31 66839.75 16 (b) Intercept X1 Coefficients Standard Error 20.577 23.367 2.442 0.537 0.489 -4.778 2.139 t Stat 0.88 4.55 1.00 P-value 0.26 0.0003 0.3328 0.0401 X2 0.489 X3 -2.23 There are many missing information in the output report. Answer the following questions to fill in the blanks. Must show detailed formulas and computations. Providing the final results only will receive at least 50% penalty. (a) What is the degrees of freedom of regression? (b) What is the total degrees of freedom? (c) What is the SSR? 3 (d) What is the MSR? (e) What is the MSE? (f) What is the Fstatistics? (g) Test the model significance at the level of significance of 0.05. State the hull hypothesis and alternate hypothesis. What is the critical F value used? Can you reject the null hypothesis? (h) What is the Rsquare? Explain the R square in the context of this model. (i) Determine if the X1 variable is significant at the level of significance of 0.05. State the hull hypothesis and alternate hypothesis. Can you reject the null hypothesis? (j) Determine if the X2 variable is significant at the level of significance of 0.05. State the hull hypothesis and alternate hypothesis. Can you reject the null hypothesis? (k) Determine if the X3 variable is significant at the level of significance of 0.05. State the hull hypothesis and alternate hypothesis. Can you reject the null hypothesis? (1) What is the adjusted R square for the model

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!