Question
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 link(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
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