Ok here is the entire assignment

Module 5 Application

Submit at the end of Module 5.

Overview: Calculating t-tests for Independent and Dependent Samples

In this Application assignment, you will conduct an independent, two-tailed test and a dependent, two-tailed test on a data set. You will use the seven-step process in conducting the two tests.

Directions

1. Review the video, t-tests in Microsoft Excel, in the multimedia presentations to understand the applications for both independent and dependent t-test measures using an Excel program.
2. Use the data sheet and enter data from 1-15 as Group A for the variable height and from 16-30 as Group B for the variable height in an Excel program.
3. Assuming equal variances, conduct a two-tailed, independent t-test on the data.
4. Next, conduct a two-tailed, dependent t-test on the data (no need to assume equality of variance in a dependent t-test).
5. Complete the seven-step process for each of the t-tests in this documents. Retain the yellow highlights for the answers. (In the Tables packet you downloaded, you will use Table 3 - Percentage Points of Student's t Distribution to determine appropriate critical value).

Part 1: Seven-Step Process for the Two-Tailed Test of Independent Samples

Step 1:Set your hypothesis.

Ho:(in statistical form)

Ha:(in statistical form)

Step 2:Determine testing Alpha Level - Alpha level = ___

Step 3:Sampling distribution = t?

Step 4:Decision RuleI will reject the Ho if my tobs value falls at or beyond my tcrit value of ______; otherwise, I will fail to reject.

Step 5:Calculate P-value in excel P-value = ______

Step 6:Since my P-value of ______ is (< or >--choose symbol) than my chosen Alpha Level of _____, I, therefore, reject or fail to reject (choose one) the null hypothesis.

Step 7:Since I rejected or failed to reject (choose one) the null hypothesis, I, therefore, conclude (fill in the conclusion based on your decision in step 6).

Part 2: Seven-Step Process for the Two-Tailed Test of Dependent Samples

Step 1:Set your hypothesis.

Ho:(in statistical form)

Ha:(in statistical form)

Step 2:Determine testing Alpha Level - Alpha level = ___

Step 3:Sampling distribution = t?

Step 4:Decision RuleI will reject the Ho if my tobs value falls at or beyond my tcrit value of ______; otherwise, I will fail to reject.

Step 5:Calculate P-value in excel P-value = ______

Step 6:Since my P-value of ______ is (< or >--choose symbol) than my chosen Alpha Level of _____, I, therefore, reject or fail to reject (choose one) the null hypothesis

Step 7: Since I rejected or failed to reject (choose one) the null hypothesis, I, therefore, conclude (fill in the conclusion based on your decision in step 6).