Correlation and Regression Analysis

by


  

Reference – Uploaded – Sun Coast.pdf

Reference – Uploaded – 29005302WK093921NResearchObjective.docx

Using the Sun Coast data set (SunCoastDataFiles_StudentGuide.xlsx), perform a correlation analysis, simple regression analysis, and multiple regression analysis, and interpret the results.

Please follow the template (Uploaded – Unit V – Template.pdf) to complete the work.

You will utilize Microsoft Excel ToolPak for this assignment.

View these links for information: https://support.office.com/en-us/article/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4 and https://www.excel-easy.com/data-analysis/analysis-toolpak.html

Example:

  • Correlation Analysis
    • Restate the hypotheses.
    • Provide data output results from Excel Toolpak.
    • Interpret the correlation analysis results   
  • Simple Regression Analysis
    • Restate the hypotheses.
    • Provide data output results from Excel Toolpak.
    • Interpret the simple regression analysis results       
  • Multiple Regression Analysis
    • Restate the hypotheses.
    • Provide data output results from Excel Toolpak.
    • Interpret the multiple regression analysis results.       

The title and reference pages do not count toward the page requirement for this assignment. This assignment should be no less than three pages in length, follow APA-style formatting and guidelines, and use references and citations as necessary.