INSTRUCTIONS:
Data Analysis: Correlation and Regression Use the Sun Coast Remediation data set to conduct a correlation analysis, simple regression analysis, and multiple regression analysis using the correlation tab, simple regression tab, and multiple regression tab respectively. Correlation Analysis In this section, provide the results of your correlation analysis. Restate the hypotheses: Ho1: There is no statistically significant relationship between height and weight. Ha1: There is a statistically significant relationship between height and weight. Create a scatter plot from the data, and enter it here. Enter data output results from Excel Toolpak here. Interpret the correlation analysis results below the Excel output. Include: r, r2, state alpha level, p value, and reject or accept the null hypothesis. For example: The Pearson correlation coefficient of r = .600 indicates a moderately strong positive correlation. This equates to an r2 of .36, explaining 36% of the variance between the variables. Using an alpha of .05, the results indicate a p value of .023 < .05. Therefore, the null hypothesis is rejected, and the alternative hypothesis is accepted that there is a statistically significant relationship between height and weight. Simple Regression Analysis Restate the hypotheses: Ho2: Ha2: Enter data output results from Excel Toolpak here. Interpret the simple regression analysis results below the Excel output. Include: multiple R, R square, state alpha level, ANOVA F value, reject or accept the null hypothesis, p value for each x variable coefficient, and express the regression model as an equation and explain. Multiple Regression Analysis Restate the hypotheses: Ha3: Ha3: Enter data output results from Excel Toolpak here. Interpret the multiple regression analysis results below the Excel output. Include multiple R, R square, state alpha level, ANOVA F value, reject or accept the null hypothesis, p value for each x variable coefficient, and express the regression model as an equation and explain. References Include references here using hanging indentations. Creswell, J. W., & Creswell, J. D. (2018). Research design: Qualitative, quantitative, and mixed methods approaches (5th ed.). SAGE. https://online.vitalsource.com/#/books/9781506386690. For more information on Correlation and Regression Data Analysis check out: https://www.britannica.com/topic/correlation-coefficient