STAT - Using the XR17-07 dataset and Microsoft Excel

profileKnowledgeCats
 (Not rated)
 (Not rated)
Chat

Using the XR17-07 dataset 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)

    • 10 years ago
    STAT - Using the XR17-07 dataset and Microsoft Excel
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      stat_-_multiple_regression_xr17-07.docx
    • attachment
      xr17-07_working_sheet.xls