Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started