Quantitative Analysis & Decision Making

Regression Modeling

Using the XR17-07 dataset (in the data sets/Excel files directory of the CD accompanying your textbook) and Microsoft Excel, build and validate a multiple regression model. Explicitly describe the following:

• Choose the dependent as well as the independent variables. Why do you think are the selected independent variables expected to cause changes in the dependent variables?
• Assess the goodness of fit of your model.
• Interpret the coefficients of the regression model. Which independent variable has the strongest impact on the dependent variables? Which independent variable has the weakest impact?
• Summarize the key business takeaways from your model. Briefly describe what the model communicates.

Submit your response in a 2- to 3-page Microsoft Word document (copying any supporting parts of the Microsoft Excel output).

Submit your document to the W4: Assignment 2 Dropbox by Week 4, Day 4.

Cite any sources using the APA format on a separate page.