Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Run a multiple linear regression using revenue as the dependent variable and all variables in the X2 variables file as the independent variables. Report the
- Run a multiple linear regression using revenue as the dependent variable and all variables in the X2 variables file as the independent variables. Report the regression line.
- Perform a global F test to determine if the model is valid at the 5% significant level.
- Interpret the coefficient for Interest rate.
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.9332593 | |||||||
R Square | 0.87097292 | |||||||
Adjusted R Square | 0.86732121 | |||||||
Standard Error | 293.770445 | |||||||
Observations | 110 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 3 | 61751263.1 | 20583754.4 | 238.510986 | 5.6798E-47 | |||
Residual | 106 | 9147913.89 | 86301.0745 | |||||
Total | 109 | 70899177 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | -1915.7308 | 1534.15176 | -1.2487231 | 0.21451719 | -4957.3358 | 1125.87431 | -4957.3358 | 1125.87431 |
Disposable income | 0.35718398 | 0.0215341 | 16.5868998 | 3.1777E-31 | 0.31449053 | 0.39987744 | 0.31449053 | 0.39987744 |
Interest rate | -21.48738 | 24.5506279 | -0.8752273 | 0.38342913 | -70.161387 | 27.1866278 | -70.161387 | 27.1866278 |
Employment | -1.5275539 | 21.9825184 | -0.0694895 | 0.94473092 | -45.110035 | 42.0549268 | -45.110035 | 42.0549268 |
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