Question

The table below contains two samples (X and Y). Please construct a test where the null hypothesis is that the population mean Y exceeds the population mean X by exactly 3. Please note that we don't know the population standard deviations and can't assume that they are equal. Please state the p-value of your test.

X Y 15 13 10 13 11 12 12 19 11 14 17 15 11 19 16 18 15 14 10 12 17 12 16 16 17 13 10 14 12 14 14 19 13 15 11 18 If the above table is not presented in a column form, then here are the two variables separately entered:

Y:

Y 13 13 12 19 14 15 19 18 14 12 12 16 13 14 14 19 15 18

X:

X 15 10 11 12 11 17 11 16 15 10 17 16 17 10 12 14 13 11

Question 13 options:

a) the p-value is 0.167

b) the p-value is 0.084

c) the p-value is 1.25

d) none of the above

Answer 1

We can directly use here Excel

Step 1) Enter data in Excel.

Step 2) Data >>Data analysis >>t-Test: Two-Sample Assuming Unequal Variances>>Select data separately >>ok

We can clearly see that it is one tailed test

P value for one tailed t test is 0.084

Option b) is correct.