psychology 54port

profilestudy2022
attachment_3.xlsx

Available Data

TASK A TASK B TASK A TASK B
Age Gender Completion Time # incorrect Age Gender Completion Time # incorrect Age Gender Completion Time # incorrect Age Gender Completion Time # incorrect
NA 50 F 79 2 NA 17 F 99 0
KA 34 F 102 0 KA 29 F 133 4
SB 21 F 237 10 SB 16 F 192 2
CM 19 F 52 3 CM 55 M 49 0
AC 23 M 240 4 AC 23 M 222 2
DC 20 M 140 0 DC 66 F 157 7
BD 22 F 91 3 BD 21 M 93 2
AD 20 F 58 3 AD 20 F 47 0
JG 25 F 660 0 JG 29 F 992 0
KG 22 F 84 0 KG 22 F 64 0
EH 45 F 171 0 EH 55 M 134 0
SJ 23 F 120 3 SJ 15 M 110 6
CM 20 F 134 1 CM 20 F 118 1
MN 21 F 140 3 MN 21 F 118 5
AO 22 F 102 1 AO 40 F 100 0
MV 21 F 421 0 MV 49 M 303 0
CV 56 F 123 12 CV 22 F 217 3
MW 56 F 69 0 MW 63 F 61 0
Correlation between completion time and age Correlation between completion time and age
-0.1834333452 -0.0438659037

Scatter plot of Time & Age

50 34 21 19 23 20 22 20 25 22 45 23 20 21 22 21 56 56 79 102 237 52 240 140 91 58 660 84 171 120 134 140 102 421 123 69

Age in years

Completion times in seconds

Scatterplot of Time & Age

17 29 16 55 23 66 21 20 29 22 55 15 20 21 40 49 22 63 99 133 192 49 222 157 93 47 992 64 134 110 118 118 100 303 217 61

Age in years

Completion times in seconds

T-test Calculations

TASK A TASK B
Completion Time Completion Time
X X
79 6241 99 9801
102 10404 133 17689
237 56169 192 36864
52 2704 49 2401
240 57600 222 49284
140 19600 157 24649
91 8281 93 8649
58 3364 47 2209
660 435600 992 984064
84 7056 64 4096
171 29241 134 17956
120 14400 110 12100
134 17956 118 13924
140 19600 118 13924
102 10404 100 10000
421 177241 303 91809
123 15129 217 47089
69 4761 61 3721
ΣX ΣX² ΣX ΣX²
3023 895751 3209 1350229
Input this information into the T Test tutorial worksheet…

Correlation Analysis

Variable A Variable B
1 1
2 2
3 3 Pearson Product Moment correlation Standard Deviation Sample A
4 4
5 5
6 6 Degrees of Freedom Standard Deviation Sample B
7 7 -2
8 8
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25 INSTRUCTIONS
26 26 Copy and paste the data that you intend to analyze in to the Variable A & B columns. You can see the patterns in the scatterplot above.
27 27
28 28
29 29
30 30
31 31
32 32
33 33
34 34 MMXIV©MRSIII
35 35
36 36
37 37
38 38
39 39
40 40
41 41
42 42
43 43
44 44
45 45
46 46
47 47
48 48
49 49
50 50
51 51
52 52
53 53
54 54
55 55
56 56
57 57
58 58
59 59
60 60
61 61
62 62
63 63
64 64
65 65
66 66
67 67
68 68
69 69
70 70
Variable A Variable B

Scatterplot of Correlation Data

Variable B

SAMPLE A (X-Axis)

SAMPLE B (Y-Axis)