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.
Sample Solution
Independent Samples t-Test:
This test is used to compare two groups of data sets and measure the difference in means between them. This can be used when comparing Sun Coast Remediation's data sets from different locations or different time periods.
Steps:
1. Organize the data into two separate samples, one for each group being compared.
2. Calculate the mean of each sample and subtract them to calculate the difference in means between them (Mean1 – Mean2).
3. Calculate the standard deviation of each sample as well as their pooled standard deviation (Pooled SD = √(SD1^2 + SD2^2) / 2).
4. Calculate the degrees of freedom (DF = n1 + n2 - 2), where n is the number of observations in each sample).
5. Use a t-test calculator or online resource to determine if there is a significant difference between your two groups using your calculated values from steps 1–4, along with an alpha level that you select prior to calculating results (e.g., .05 for 95% confidence interval).