https://mywaycool.nebraska.edu/courses/MTHH039059/...

Data Analysis: Hypothesis TestingUse the Sun Coast Remediation data set to conduct an independent samples t test, dependent samples (paired samples) t test, and ANOVA using the independent samples tab, paired samples tab, and ANOVA tab in the Sun Coast data file. The statistical output tables should be cut and pasted from Excel directly into the final project document.Independent Samples t Test: Hypothesis TestingRestate the null and alternative hypotheses, cut and paste the statistical output from Excel Toolpak, discuss the p value in relation to alpha, and explicitly accept or reject the null and alternative hypotheses. See example below:Ho4: There is no statistically significant difference in mean values for the DV between Group A (IV1) and Group B (IV2).Ha4: There is a statistically significant difference in mean values for the DV between Group A (IV1) and Group B (IV2).Provide data output results from Excel Toolpak here. See example below:Interpret and explain the independent t test results below the Excel output here. Include alpha level, p value, and reject or accept the null hypothesis.Example:The results indicate that the mean values are lower for Group A; however, the results also indicate a p value of .37627 > .05. Therefore, the null hypothesis is accepted that there is no statistically significant difference in mean values of the DV between Group A (IV1) and Group B (IV2).Dependent Samples (Paired Samples) t Test: Hypothesis TestingRestate the hypotheses here.Provide data output results from Excel Toolpak here.Interpret and explain the dependent t test results below the Excel output here. Include alpha level, p value, and accept or reject the null and alternative hypotheses.ANOVA: Hypothesis TestingRestate the hypotheses here.Provide data output results from Excel Toolpak here.Interpret and explain the ANOVA results below the Excel output here. Include alpha level, p value, and accept or reject the null and alternative hypotheses.