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.
| Assignment 2 Grading Criteria |
Maximum Points
|
|---|---|
| Explained why the selected independent variables are expected to cause changes in the dependent variables. |
5
|
| Assessed the goodness of fit of your model. |
5
|
| Explained which independent variable has the strongest impact on the dependent variables and which one has the weakest. |
10
|
| Summarized the key business takeaways from your model. |
10
|
| Presented a structured document free of spelling and grammatical errors. |
5
|
| Cited all sources using the APA format. |
5
|
| Total: |
0 comments