Question: 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

  1. 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.
  2. Perform a global F test to determine if the model is valid at the 5% significant level.
  3. 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

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!

Q:

TR 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 SALES 88 80 96 76 80 73 58 116 104 99 64 126 94 71 111 109 100 TV 100 99 101 93 95 95 80 116 106 105 90 113 96 98 109 102 100 RADIO 95 99 103 95 102 94 89 112 110...

Q:

You want to run a multiple linear regression. Let y be the dependent variable and x1 and x2 are the independent variables. Provide the following: - Run a linear regression using Excel's Data Analysis...

Q:

Need Urgent Help with Question 3 and Question 9 of the attached document - Question 3 needs only ~400 words (also attaching an article which might be needed to answer question-3) My word count for...

Q:

SUMMARY OUTPUT Regression Statistics Multiple R 0.05860241 R Square 0.00343424 Adjusted RS -2.191E-06 Standard Err 660937.324 Observations 292 ANOVA df Regression Residual Total SS MS F Significance...

Q:

Run a multiple linear regression using GAP revenue as the dependent variable and all variables in the X1 variables file as the independent variables. Report the regression line. Perform a global F...

Q:

Business performance can be affected various economic factors. Data on Sears revenue and interest rate (X4) are collected in an effort to study the relationship between company revenue and interest...

Q:

Answer all questions.,,, You may be interested in studying effects of various firm-specific factors on the returns of a sample of 200 firms. You run cross-sectional regression with 200 firms and...

Q:

1. Based on your hypothesis, you believe a respondent's self-reported poor health is related to their demographics (_AGE_G, SEX1, _RACE_G1, _EDUCAG) and other select factors (_BMI5, AVEDRNK2, and...

Q:

For this assignment, use the "Example Dataset" to complete a simple linear regression using SPSS. Select one dependent variable, one primary independent variable, and one potential confounding...

Q:

AGEC 440 Homework #3 100 Points Available This Homework Will Use the Homework 3 Excel Data Sheet (Data Tab) Please carry any decimals out two places if numbers are involved in your answer. 1....

Q:

Consider the following cash flows of two mutually exclusive projects for AZ-Motorcars. Assume the discount rate for AZ-Motorcars is 10 percent. a. Based on the payback period, which project should be...

Q:

The file MATHPNL.RAW contains panel data on school districts in Michigan for the years 1992 through 1998. It is the district-level analogue of the school-level data used by Papke (2005). The response...

Q:

3 9 of 5 0 Meek's is considering a five - year project that will require $ 7 3 8 , 0 0 0 for new fixed assets that will be depreclated straight - line to a zero boole value over five years. No bonus...

Q:

Blendit (BLD) just developed new universal titanium replacement mixer blades. These replacement blades can be used in most mixers currently on the market. BLD is selling these blades with a right of...