Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

First start the section with a short paragraph to introduce the regression analysis that's to be presented. I have selected 3 variables(Household Net Worth, Price

First start the section with a short paragraph to introduce the regression analysis that's to be presented.

I have selected 3 variables(Household Net Worth, Price Index, GDP) that I believe can be correlated with my company's revenue data. These variables are the independent variables Xs. The selection is based on your understanding and intuition. Please answer the questions using Mintab and the doc sharing link(data). If you request access, I will share the data.

https://drive.google.com/file/d/1IY9x5kJHN5OLebyMdFc1GEhVEssLkLzv/view?usp=sharing

a.Report the correlation matrix of Y and all Xs.

b.Based on the correlation matrix, discuss the relationship between y and each x. Are they highly correlated? Is the relationship positive or negative?

c.Run a multiple linear regression model. Make sure to have Minitab report the VIF and DW.

d.Explain your results. You need to first copy and paste the corresponding part of the output from Minitab before providing your analysis and interpretation. Providing all output at once is NOT allowed.

Check the validity of the model using the F-test. State the criteria and conclusion.

Interpret regression coefficients; do they make sense to you?

Which variables are significant? Which are not? Make sure to state your judgement criteria

Do you have a good overall fit of the model? Make sure you discuss the criteria used.

Is there multicollinearity? Which measure you used to check multicollinearity? What is the criteria?

Check for autocorrelation using the DW statistic. Do you have autocorrelation?

Check residuals. Are the assumptions on residuals satisfied?

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

Rediscovering Sustainability Economics Of The Finite Earth

Authors: ARG Heesterman

1st Edition

1317069846, 9781317069843

More Books

Students also viewed these Economics questions