Using the Sun Coast data set, perform a correlation analysis, simple regression analysis, and multiple regression analysis, and interpret the results.
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.
Sample Solution