Reference no: EM132279630
Assignment - SPSS Paired t-Test, Wilcoxon Signed-Rank Test
1. Please import the provided Excel dataset and preview the document to SPSS to see if you can produce the following output that aligns with the two prompts.
2. Please share whether you are able to produce the same output and state what the results reveal to you.
Complete the following:
PART I -
Conduct a paired t-test to assess whether significant mean differences exist between Pretest 1 and Posttest 1 scores among the one sample of students.
Paired Samples Statistics -
|
|
Mean
|
N
|
Std. Deviation
|
Std. Error
|
Pair 1
|
PreTest 1
|
82.23
|
30
|
5.386
|
.983
|
|
Post Test 1
|
84.33
|
30
|
7.038
|
1.285
|
Paired Samples Correlations -
|
|
N
|
Correlation
|
Sig.
|
Pair 1
|
PreTest 1 & PostTest 1
|
30
|
.687
|
.000
|
Paired Samples Test -
Paired Differences
|
|
|
|
|
|
95% Confidence Interval of the Difference
|
|
|
|
|
|
Mean
|
Std. Deviation
|
Std. Error Mean
|
Lower
|
Upper
|
t
|
df
|
Sig. (2-tailed)
|
Pair 1
|
PreTest 1 - PostTest 1
|
-2.100
|
5.142
|
.939
|
-4.020
|
-.180
|
-2.237
|
29
|
.033
|
PART II -
Conduct a Wilcoxon Signed-Rank test to assess whether significant mean differences exist between Pretest 1 and Posttest 1 scores among the one sample of students.
Wilcoxon Signed-Rank Test
Ranks
|
|
|
N
|
Mean Rank
|
Sum of Ranks
|
PostTest 1 - PreTest 1
|
Negative Ranks
|
9a
|
11.72
|
105.50
|
Positive Ranks
|
18b
|
15.14
|
272.50
|
Ties
|
3c
|
|
|
Total
|
30
|
|
|
a. PostTest 1 < PreTest 1
b. PostTest 1 > PreTest 1
c. PostTest 1 = PreTest 1
Test Statisticsa
|
PostTest 1 - PreTest 1
|
Z
|
-2.012b
|
Asymp. Sig. (2-tailed)
|
.044
|
a. Wilcoxon Signed Ranks Test.
b. Based on negative ranks.
Note - Please complete the two questions using the provided Excel dataset.
Attachment:- Assignment Files.rar