Scholarly Activity

Scholarly Activity

 

Using t Test and ANOVA With Sun Coast Remediation Data Set

Using 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 Test
    • Restate the hypotheses.
    • Provide data output results from Excel Toolpak.
    • Interpret the t Test results
  • Dependent Sample t Test
    • Restate the hypotheses.
    • Provide data output results from Excel Toolpak.
    • Interpret the t Test results
  • ANOVA
    • Restate the hypotheses.
    • Provide data output results from Excel Toolpak.
    • Interpret the ANOVA results.

Please follow the Scholarly Activity template 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.

 

Use at least 3 references.

 

 

 

 

 

 

 

 

 

 

 

Insert Title Here

Insert Your Name Here

Insert University Here

 

 

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:

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.

 

 

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.