Question: b. An excel analysis was applied to data collected from a random sample of 100 people in order to preform regression analysis for the prediction

 b. An excel analysis was applied to data collected from a

b. An excel analysis was applied to data collected from a random sample of 100 people in order to preform regression analysis for the prediction of variable Y using the values of 3 predictors: X1, X2, X3. The following output was obtained (omitting some entries). Regression Statistics Multiple R R Square Adjusted R Square Standard Error 2.229 Observations 100 ANOVA SS MS F Regression 141.77 Residual 476.98 Total Coefficients SE t Stat P-value Lower 95% Upper 95% Intercept -0.643 3.400 -0.189 0.850485 -7.392 6.107 X1 -0.111 0.084 -0.278 0.056 X2 0.395 0.082 0.233 0.558 X3 0.073 0.047 -0.021 0.166 (Note: since the sample is large, in sections where the t distribution is needed, you can use the Z one) i. Use a significance level of 1% to test if the entire regression model is significant. ii. Test which of the predictors is significant using a significance level of 1%

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 Mathematics Questions!