Question

Data Set

Height	Weight	Age	Shoe Size	Waist Size	Pocket Change
64	180	39	7	36	18
66	140	31	9	30	125
69	130	31	9	25	151
63	125	36	7	25	11
68	155	24	8	31	151
62	129	42	6	32	214
63	173	30	8	34	138
60	102	26	6	25	67
66	180	33	8	30	285
66	130	31	9	30	50
63	125	32	8	26	32
68	145	33	10	28	118
75	235	44	12	40	60
68	138	43	8	27	50
65	165	55	9	30	22
64	140	24	7	31	95
78	240	40	9	38	109
71	163	28	7	32	14
68	195	24	10	36	5
66	122	33	9	26	170
53	115	25	7	25	36
71	210	30	10	36	50
78	108	23	7	22	75
69	126	23	8	24	175
77	215	24	12	36	41
68	125	23	8	30	36
62	105	50	6	24	235
69	126	42	9	27	130
55	140	42	8	29	14
67	145	30	8	30	50

1.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.

2.Assuming equal variances, conduct a two-tailed, independent t-test on the data.

3.Next, conduct a two-tailed, dependent t-test on the data (no need to assume equality of variance in a dependent t-test).

4.Complete the seven-step process for each of the t-tests in this documents.

5.Answer all three parts o this assignment, including the writen portion at the end.

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 Rule—I 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 Rule—I 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 3: Contrasting the Independent and Dependent Tests

In a brief paragraph, discuss your reasoning for any differences between the two tests in the seven-step process.

Answer 1

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

The test is performed in excel by following these steps,

Step1: Write the data values in excel. The screenshot is shown below,

Step 2: DATA > Data Analysis > t-test: Two-Sample Assuming Equal Variances.

Step 3: Input Variable 1 Range: Group A column, Variable 2 Range: Group B column, Hypothesized Mean Differences: 0, Alpha = 0.05

The result is obtained,

Step 1: Set your hypothesis.

Ho:

Ha:

Step 2: Determine testing Alpha Level – Alpha level = 0.05

Step 3: Sampling distribution = t-distribution.

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

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

Step 6: Since my P-value of 0.352 is > than my chosen Alpha Level of 0.05, I, therefore, fail to reject the null hypothesis.

Step 7: Since failed to reject the null hypothesis, I, therefore, conclude that there no statistically significant difference in two group means.

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

The test is performed in excel by following these steps,

Step1: Write the data values in excel.

Step 2: DATA > Data Analysis > t-test: Two-Sample Assuming Unequal Variances.

Step 3: Input Variable 1 Range: Group A column, Variable 2 Range: Group B column, Hypothesized Mean Differences: 0, Alpha = 0.05

The result is obtained. The screenshot is shown below,

Step 1: Set your hypothesis.

Ho:

Ha:

Step 2: Determine testing Alpha Level – Alpha level = 0.05

Step 3: Sampling distribution = t-distribution.

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

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

Step 6: Since my P-value of 0.354 is > than my chosen Alpha Level of 0.05, I, therefore, fail to reject the null hypothesis.

Step 7: Since failed to reject the null hypothesis, I, therefore, conclude that there no statistically significant difference in two group means.

Part 3: Contrasting the Independent and Dependent Tests

From the descriptive statistics summary we can see that, there is a big difference in the variance of two groups that is why there is minor change in the t critical value and p-value.