Psychology week 7 assignment

profilebmarlurer8
ProgramevaluationDataSetweek6assignmenttwo.xlsx
Home>Psychology homework help>Psychology week 7 assignment

Sheet1

ID Age Gender Race_Ethnicity Treatment_Weeks SDQ_pre SDQ_post CANS_pre CANS_post YOQ_pre YOQ_post PHQA_pre PHQA_post GAD7_pre GAD7_post PSS_pre PSS_post GAD7_diff GAD7_pair_status GAD7_diff_z Outlier_flag Abs_diff Rank Sign Signed_rank
1 16 Male Latino 17 22 18 13 10 92 86 13 11 7 4 19 12 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83 Median (pre) 10 Median (post) 9
2 15 Male Black 9 20 18 13 10 85 72 14 11 19 17 24 18 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5 Q1 (25th percentile, pre) 7 Q1 (post) 5
3 17 Male Latino 14 24 21 17 14 59 51 14 12 14 13 13 5 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5 Q3 (75th percentile, pre) 13 Q3 (post) 11
4 19 Male Black 15 17 15 13 10 98 84 14 12 9 7 23 16 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5 IQR (pre) 6 IQR (post) 6
5 14 Nonbinary White 8 25 17 16 14 66 15 12 0 0 22 17 0 Complete_pair -1.3550809074 Normal_range 0 4 ERROR:#VALUE!
6 14 Male Latino 12 31 27 25 23 83 81 17 18 19 17 25 24 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
7 19 Female White 4 21 19 19 16 158.4 148.5 13 10 4 2 23 18 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5 Time Median_GAD7
8 17 Female White 8 24 20 13 11 78 59 15 15 3 2 16 13 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5 Pre 10
9 14 Male Latino 11 26 22 21 19 109 102 12 10 14 12 29 26 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5 Post 9
10 16 Nonbinary White 7 20 16 13 10 62 54 18 17 20 19 21 15 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
11 14 Nonbinary Multiracial 19 23 18 5 2 79 68 9 9 16 14 22 13 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
12 14 Male Multiracial 6 22 17 10 5 124 113 19 16 12 11 16 10 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
13 16 Female Multiracial 10 23 6 7 64 51 12 10 12 11 19 17 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
14 10 Male White 13 17 15 13 9 125 105 6 4 13 10 17 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
15 11 Male White 18 22 19 15 10 98 89 13 11 13 10 21 13 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
16 14 Male Multiracial 6 25 26 23 23 66 60 9 7 11 32 29 11 Missing_pair 5.8737697142 Potential_outlier 11 100 1 100
17 12 Female Black 17 31 30 17 96 93 15 13 10 10 14 9 0 Complete_pair -1.3550809074 Normal_range 0 4 ERROR:#VALUE!
18 16 Female Other 12 28 21 14 11 104 98 9 9 10 8 12 7 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
19 13 Male Other 8 35 28 19 18 96 86 10 7 7 4 31 28 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
20 11 Male Asian 14 38.5 37.4 4 2 41 22 23.1 22 9 7 21 14 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
21 19 Female White 13 27 22 16 15 62 54 10 10 3 0 18 13 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
22 14 Male White 10 23 18 19 13 74 63 2 1 10 7 28 22 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
23 15 Male Asian 12 35 25 8 3 78 68 6 2 22 20.9 18 16 1.1 Complete_pair -0.6321958453 Normal_range 1.1 30.5 1 30.5
24 11 Female White 10 17 11 21 16 96 80 15 12 6 33 29 6 Missing_pair 2.5879285226 Normal_range 6 98 1 98
25 14 Nonbinary White 12 17 13 17 13 84 62 15 13 11 9 26 19 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
26 15 Male Latino 15 38.5 37.4 13 12 47 39 14 12 16 14 19 15 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
27 12 Female Multiracial 18 9 8 18 16 90 82 8 6 14 11 41.8 38.5 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
28 16 Female Latino 7 19 14 26 23 95 80 12 8 4 1 18 14 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
29 13 Male Latino 21 17 15 16 15 94 81 12 10 6 5 26 21 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
30 14 Female White 4 23 22 16 12 107 88 23.1 22 14 13 24 16 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
31 13 Male Latino 11 24 21 13 10 101 88 18 15 6 6 30 28 0 Complete_pair -1.3550809074 Normal_range 0 4 ERROR:#VALUE!
32 20 Female Other 14 33 31 11 8 91 83 16 13 9 7 31 31 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
33 15 Female White 13 28 20 19 15 78 65 11 9 12 11 22 21 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
34 12 Female Black 10 19 13 11 7 38 23 12 10 6 6 17 9 0 Complete_pair -1.3550809074 Normal_range 0 4 ERROR:#VALUE!
35 17 Male Asian 11 17 13 15 91 77 13 11 10 8 25 21 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
36 12 Female Latino 10 25 18 13 8 85 73 4 2 5 0 18 7 5 Complete_pair 1.9307602842 Normal_range 5 97 1 97
37 16 Male Latino 10 14 10 17 16 87 71 11 8 8 6 34 30 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
38 10 Male Latino 15 33 31 17 13 48 32 9 7 11 8 23 17 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
39 12 Male White 13 29 22 20 16 53 36 8 5 4 2 20 11 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
40 15 Female White 9 19 14 12 10 106 93 11 9 12 10 41.8 38.5 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
41 17 Female Asian 16 12 10 14 10 79 70 19 17 10 7 14 4 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
42 15 Male Asian 13 30 27 10 9 97 86 15 15 12 11 16 8 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
43 15 Female Asian 15 21 19 13 8 81 65 10 7 11 9 29 22 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
44 14 Male Multiracial 15 29 28 17 14 81 75 14 12 15 13 18 12 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
45 11 Female Black 9 12 7 19 17 103 18 15 11 9 16 9 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
46 13 Male Black 10 18 11 10 6 67 59 16 17 8 5 25 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
47 14 Female Latino 15 22 21 19 17 82 72 12 8 10 9 29 26 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
48 18 Male Latino 14 22 17 22 21 68 52 9 8 12 11 26 21 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
49 16 Female Latino 12 19 17 17 16 69 58 15 12 10 8 28 23 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
50 11 Male Latino 12 26 23 24 20 72 62 14 13 10 9 17 14 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
51 16 Male Multiracial 17 16 13 11 10 86 82 16 7 5 13 7 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
52 14 Male White 10 21 9 3 68 54 15 14 7 5 31 24 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
53 13 Female White 14 23 19 6 6 111 98 16 15 4 1 20 15 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
54 17 Female White 11 25 23 22 17 58 10 6 17 15 20 12 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
55 18 Male Latino 11 26 22 18 15 75 67 17 15 5 3 30 28 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
56 17 Female White 16 15 11 15 12 69 58 13 11 7 4 25 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
57 13 Female Black 15 13 9 16 14 116 105 20 7 4 25 22 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
58 14 Female Black 15 30 27 9 6 85 67 9 7 14 11 35 35 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
59 16 Female White 17 24 21 27 24 106 96 19 17 9 7 18 13 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
60 17 Male Latino 12 18 12 16 11 158.4 148.5 13 10 15 14 28 23 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
61 14 Male White 15 31 26 16 12 87 74 9 5 7 6 22 14 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
62 15 Female White 11 23 21 19 15 102 91 10 8 11 9 24 17 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
63 12 Female Asian 13 29 25 17 15 82 74 11 9 7 5 31 29 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
64 12 Female White 11 22 17 16 13 107 96 14 11 19 17 25 15 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
65 17 Male White 12 34 34 11 8 67 52 14 11 5 3 25 17 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
66 18 Male Black 14 33 27 17 17 115 110 10 7 11 9 28 22 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
67 15 Female Latino 9 21 18 24 23 137 127 12 9 13 11 20 15 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
68 18 Female White 20 28 23 22 71 64 21 20 12 9 17 14 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
69 16 Female Latino 8 26 23 23 20 69 53 19 15 9 7 16 12 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
70 13 Female White 7 30 30 12 10 116 114 14 13 9 9 10 2 0 Complete_pair -1.3550809074 Normal_range 0 4 ERROR:#VALUE!
71 16 Female White 17 16 15 30.8 28.6 119 112 12 10 10 9 34 25 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
72 19 Male Black 15 26 22 14 11 67 55 12 11 9 8 15 7 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
73 15 Male Black 14 28 24 15 13 69 52 14 13 14 13 21 17 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
74 19 Female Latino 15 11 9 30.8 28.6 73 63 8 6 19 16 20 18 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
75 10 Female Latino 12 15 10 7 3 46 39 11 9 8 4 24 18 4 Complete_pair 1.2735920459 Normal_range 4 95.5 1 95.5
76 17 Male Other 8 10 9 23 21 57 38 5 3 5 1 27 26 4 Complete_pair 1.2735920459 Normal_range 4 95.5 1 95.5
77 15 Male Black 12 20 17 14 11 55 52 14 10 10 8 27 21 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
78 14 Female White 9 26 25 13 12 61 62 15 12 20 17 19 14 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
79 15 Male Latino 16 31 28 10 5 79 67 10 8 7 21 17 7 Missing_pair 3.2450967609 Potential_outlier 7 99 1 99
80 10 Male White 11 22 18 7 3 86 78 18 15 17 15 24 23 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
81 14 Female Black 9 32 19 16 119 114 7 4 17 15 21 14 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
82 16 Female White 11 14 10 15 11 55 41 6 5 22 20.9 32 28 1.1 Complete_pair -0.6321958453 Normal_range 1.1 30.5 1 30.5
83 19 Female White 14 12 6 9 3 105 93 13 10 12 11 25 23 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
84 14 Male Other 10 22 19 9 4 75 67 16 13 17 14 26 29 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
85 13 Female Asian 9 24 19 13 13 79 75 19 17 8 6 26 21 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
86 14 Male Latino 13 22 20 23 22 97 83 10 7 9 7 29 20 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
87 17 Male Black 13 10 5 14 12 52 39 16 14 8 5 23 14 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
88 16 Female White 10 21 15 7 4 90 80 12 10 6 3 14 10 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
89 14 Female White 10 14 15 14 10 84 65 11 9 7 4 24 21 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
90 16 Female White 13 26 24 14 12 92 88 16 14 5 5 18 12 0 Complete_pair -1.3550809074 Normal_range 0 4 ERROR:#VALUE!
91 15 Female Black 6 24 19 2 0 87 85 15 14 10 11 19 16 -1 Complete_pair -2.0122491458 Normal_range 1 18.5 -1 -18.5
92 17 Female Latino 6 16 13 15 13 141 135 6 7 4 26 20 3 Complete_pair 0.6164238076 Normal_range 3 83 1 83
93 13 Male Latino 9 19 14 14 12 64 54 18 14 11 10 29 23 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
94 14 Male White 11 16 13 18 18 67 56 18 16 4 2 22 14 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
95 14 Male Multiracial 13 22 17 24 23 64 56 9 8 11 10 24 19 1 Complete_pair -0.6979126691 Normal_range 1 18.5 1 18.5
96 11 Male Latino 18 28 24 21 20 66 54 14 14 13 13 32 28 0 Complete_pair -1.3550809074 Normal_range 0 4 ERROR:#VALUE!
97 16 Nonbinary Latino 15 16 10 14 12 64 60 14 13 2 0 23 21 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
98 16 Male Latino 11 25 21 9 5 110 93 13 12 11 9 38 35 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
99 15 Female Black 12 19 14 28 26 116 106 10 6 15 13 25 21 2 Complete_pair -0.0407444308 Normal_range 2 51.5 1 51.5
100 14 Female White 8 17 14 15 8 66 50 9 6 5 6 11 6 -1 Complete_pair -2.0122491458 Normal_range 1 18.5 -1 -18.5
Mean 2.062 Sum of positive signed ranks (T+): 4985
Stdv 1.5216803577 Sum of negative signed ranks (T−): -37
Wilcoxon W 37
skewness 2.3691321442
kurtosis 12.2541276869
n 93
Complete 97 mean 2185.5
Missing 3 std 260.9880265453
Potentia outlier 2 z stats -8.23217842
effect size r -0.8536371364

Median GAD-7 Anxiety Scores Pre- and Post-Program

Median_GAD7

Pre Post 10 9

Time

GAD-7 Score

Sheet2

Sum of positive signed ranks (T+): 4985
Sum of negative signed ranks (T−): -37
Wilcoxon W 37
n 93
mean 2185.5
std 260.9880265453
z stats -8.23217842
effect size r -0.8536371364
Column1 Column2 Column3 Column4
Median (pre) 10 Median (post) 9
Q1 (25th percentile, pre) 7 Q1 (post) 5
Q3 (75th percentile, pre) 13 Q3 (post) 11
IQR (pre) 6 IQR (post) 6