Expert Answer:Using t Test and ANOVA With Sun Coast Remediation

Answer & Explanation:Due: Tuesday, 11/12/2019 11:59 PM (CST)InstructionsUsing t Test and ANOVA With Sun Coast Remediation Data SetUsing the Sun Coast Remediation data set, perform an independent samples t Test, dependent samples t Test, and ANOVA, and interpret the results.You will utilize Microsoft Excel Toolpak for this assignment.Example:Independent Sample t TestRestate the hypotheses.Provide data output results from Excel Toolpak.Interpret the t Test results Dependent Sample t TestRestate the hypotheses.Provide data output results from Excel Toolpak.Interpret the t Test results ANOVARestate the hypotheses.Provide data output results from Excel Toolpak.Interpret the ANOVA results.Please follow the Unit VI Scholarly Activity template here to complete your assignment.The title and reference pages do not count toward the page requirement for this assignment. This assignment should be no less than two pages in length, follow APA-style formatting and guidelines, and use references and citations as necessary.
unitvi_template.docx

Unformatted Attachment Preview

Running head: INSERT TITLE HERE
1
Insert Title Here
Insert Your Name Here
Insert University Here
INSERT TITLE HERE
2
Data Analysis: Hypothesis Testing
Use 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 Testing
Restate 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:
INSERT TITLE HERE
3
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 Testing
Restate 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 Testing
Restate 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.
INSERT TITLE HERE
4
References
Include references here using hanging indentations. Remember to remove this example.
Creswell, J. W., & Creswell, J. D. (2018). Research design: Qualitative, quantitative, and mixed
methods approaches (5th ed.). Thousand Oaks, CA: Sage.
…
Purchase answer to see full
attachment