Question

Here is a link to the data set collected by the researchers containing patient responses concerning the level of pain relief they experienced over the course of the study.

Treatment	Placebo
1	1
1	1
1	1
1	1
1	1
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
3	5
3	5
3	5
3	5
3	5
3	5
3	5
3	6
3	6
3	6
3	6
3	6
3	6
4	6
4	6
4	7
4	7
4	7
4	7
4	7
4	7
5	7
5	7
5	7
5	7
5	7
5	7
5	7
6	7
6	8
6	8
6	8
6	8
7	8
7	8
7	8
7	8
7	8
7	8
8	8
8	8
8	9
8	9
8	9
8	9
9	9
9	9
9	9
9	10
9	10
10	10
10	10
10	10
10	10
10	10

Perform the correct statistical test to determine the P value. Report your answer rounded to four decimal places.

Use formulas, functions, and the data analysis tool pack in Excel to avoid accruing rounding errors. Useful functions include

=t.test(array1,array2,tails,type)

to produce a P value for any type of a t test from a data set

=chidist(x,degrees of freedom)

to produce a P value from a calculated chi squared statistic

ANOVA Single Factor from the data analysis tool pack

to perform a 1-way ANOVA on a data set with only one factor

ANOVA 2-Factor from the data analysis tool pack

to perform an ANOVA on data with multiple treatments

Regression from the data analysis tool pack

to perform a linear regression and the corresponding t-test on the slope of the line

P-Value ________?

Answer 1

This is a case of t test . However it is not given whether the data is from independent samples or not. So lets assume that the 2 datasets comes from 2 independent samples and the procedure to conduct the t test is as follows in excel.

The Hypothesis is

H0: There is no significant difference between the treatment and the placebo

H1: There is a significant difference between the treatment and the placebo

also , lets consider the alpha as 0.05 , so if the p value is less than 0.05 we reject the null hypothesis

as the p value is 0.0003, which is less than 0.05 hence we reject null hypothesis

Please note that rest of the methods are not applicable for the given data