Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The management team of a large company is studying the relationship between employees monthly expenditures (y in dollars) and three factors: The mortgage payment (x

The management team of a large company is studying the relationship between employees monthly expenditures (y in dollars) and three factors: The mortgage payment (x1 in dollars), the value of the company vehicles (x2 in dollars), and the average age of the employees (x3 in years). As part of the analysis, you generated the multiple regression output in exhibit 1.

SUMMARY OUTPUT [Exhibit 1]
Regression Statistics
Multiple R 0.9346963
R Square 0.8736572
Adjusted R Square 0.831543
Standard Error 273.68116
Observations 13
ANOVA
Df SS MS F Significance F
Regression 3 4661472 1553823.9 20.7493 0.0002218
Residual 9 674112.4 74901.378
Total 12 5335584
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept -948.63602 908.4818 -1.044199 0.323628 -3003.766 1106.494
Mortgage Payment (x1) 1.5149792 0.632857 2.3938731 0.040301 0.0833562 2.946602
Vehicle Value (x2) 0.2137534 0.030148 7.0900756 5.73E-05 0.1455532 0.281954
Age (x3) 49.541875 26.31039 1.8829779 0.092366 -9.976397 109.0601

Required:

(a) State four (4) assumptions of the multiple linear regression model. [4marks]

(b) By outlining the F-test, comment on the overall adequacy of the multiple linear regression Model (use 5% level of significance). [4marks]

(c) Write out the estimated regression equation from the output in exhibit 1. [2marks]

(d) Interpret each of the estimated regression coefficients of the regression model. [6marks]

(e) By outlining the T-test, comment on the significance of each of the explanatory variables in the estimated regression equation (Assume 5% level of significance). [6marks]

(f) State and interpret the adjusted R.

[3marks]

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_2

Step: 3

blur-text-image_3

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

Real Analysis On Intervals

Authors: A D R Choudary, Constantin P Niculescu

1st Edition

8132221486, 9788132221487

More Books

Students also viewed these Mathematics questions

Question

What does stickiest refer to in regard to social media

Answered: 1 week ago