Correlation and Regression Analysis Using Sun Coast Data Set
Using the Sun Coast data set, perform a correlation analysis, simple regression analysis, and multiple
regression analysis, and interpret the results.
Please follow the Unit V Scholarly Activity template to complete your assignment.
You will utilize Microsoft Excel ToolPak for this assignment.
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.
Sample Solution