Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts In Complex Analysis

Authors: Rashmi Rana

1st Edition

9353146461, 9789353146467

More Books

Students also viewed these Mathematics questions

Question

Always have the dignity of the other or others as a backdrop.

Answered: 1 week ago