Reference no: EM132400231
Statistical Methods Assignment Problem -
Using the attached data set, answer the following USING EXCEL:
PLEASE RUN THE CORRELATION, it will reveal WHICH VARIABLE should be the dependent.
1. Generate the regression output for the best-fit model (Just one model, one table. Discuss the Adj. R-sq, any use of dummy variables, time trend, natural log, etc).
2. Explain in detail the relationship between ALL independent variables and the dependent variable (direction, magnitude and significance).
3. Plot and discuss the residual.
Instructions (failing to follow the instructions will cost you points):
1. Be concise, factual, and deliberate with your answers.
2. Excel work with DATA, MUST be shared, as well as the output table in word, on separate file attachment.
3. 1 question per page and number the pages.
Attachment:- Statistical Methods Assignment & Data File.rar