Week 4 Assignment 2

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).

Name your document SU_MBA5008_W4_A2_LastName_FirstInitial.doc.

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.