PSYC 203 FINAL ASSIGNMENT - STATISTICS

profiledvargas96
DATASET_07.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
TW 19 M 162 3 TW 21 F 169 1
SN 29 M 230 1 SN 27 F 219 0
EA 23 F 209 8 EA 19 M 137 4
KM 35 F 346 5 KM 57 M 108 7
PM 19 F 130 3 PM 22 M 165 0
AD 23 M 80 4 AD 26 F 73 2
QN 20 M 119 1 QN 21 F 94 0
NG 16 F 210 9 NG 20 F 167 2
CL 21 F 72 1 CL 23 M 105 2
KD 53 F 315 4 KD 56 M 219 0
SK 33 M 387 6 SK 34 M 239 2
CJ 26 M 100 2 CJ 22 F 115 4
SW 31 M 82 1 SW 20 F 230 3
AO 19 M 98 1 AO 17 M 79 0
NK 30 M 91 0 NK 23 M 98 1
MK 22 M 112 8 MK 43 F 141 8
PL 28 F 216 3 PL 21 M 162 1
GA 25 F 135 3 GA 32 M 163 1
JK 20 F 161 8 JK 21 F 101 2
CR 21 F 278 4 CR 21 F 237 6
BQ 20 F 142 0 BQ 23 M 154 0
DV 22 F 227 4 DV 20 F 357 3
MR 56 M 149 4 MR 51 F 247 6
MR 47 F 62 2 MR 49 M 51 3
EN 19 F 108 2 EN 52 M 170 10
NA 21 F 52 1 NA 17 F 79 4
LP 64 M 79 0 LP 58 F 70 3
TR 20 F 111 6 TR 23 F 128 9
WM 24 F 147 2 WM 28 M 137 0
VV 53 M 87 0 VV 25 M 116 1
AS 17 F 80 2 AS 11 M 96 3
Correlation between completion time and age Correlation between completion time and age
0.0721782069 0.0138585245

Scatter plot of Time & Age

19 29 23 35 19 23 20 16 21 53 33 26 31 19 30 22 28 25 20 21 20 22 56 47 19 21 64 20 24 53 17 162 230 209 346 130 80 119 210 72 315 387 100 82 98 91 112 216 135 161 278 142 227 149 62 108 52 79 111 147 87 80

Age in years

Completion times in seconds

Scatterplot of Time & Age

21 27 19 57 22 26 21 20 23 56 34 22 20 17 23 43 21 32 21 21 23 20 51 49 52 17 58 23 28 25 11 169 219 137 108 165 73 94 167 105 219 239 115 230 79 98 141 162 163 101 237 154 357 247 51 170 79 70 128 137 116 96

Age in years

Completion times in seconds

T-test Calculations

TASK A TASK B
Completion Time Completion Time
X X
162 26244 169 28561
230 52900 219 47961
209 43681 137 18769
346 119716 108 11664
130 16900 165 27225
80 6400 73 5329
119 14161 94 8836
210 44100 167 27889
72 5184 105 11025
315 99225 219 47961
387 149769 239 57121
100 10000 115 13225
82 6724 230 52900
98 9604 79 6241
91 8281 98 9604
112 12544 141 19881
216 46656 162 26244
135 18225 163 26569
161 25921 101 10201
278 77284 237 56169
142 20164 154 23716
227 51529 357 127449
149 22201 247 61009
62 3844 51 2601
108 11664 170 28900
52 2704 79 6241
79 6241 70 4900
111 12321 128 16384
147 21609 137 18769
87 7569 116 13456
80 6400 96 9216
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
ΣX ΣX² ΣX ΣX²
4777 959765 4626 826016
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 ERROR:#DIV/0! ERROR:#DIV/0!
5 5
6 6 Degrees of Freedom Standard Deviation Sample B
7 7 -2 ERROR:#DIV/0!
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)