Connections

[Maryam Rahat]

I have the raw data from the administration of Connections on a number of participants.
However, the summary report has not been saved.
Is there a way for me to calculate the metics relevant to result summary reports from the raw data?
Please and thank you.

[Shane T Mueller]

The summary stats saved to the report are pretty minimal, and should be computable easily via excel or R or Python code. I just keep track of, for single and switch trials separately:

Number of targets (The more the better)
RT (should not even differ because there is a 20 second time limit in both conditions)
Clicks (counts extra clicks, probably not useful; essentially the same as targets)
overclicks (even less useful probably)

Here is a sample file:

---------------------------------------
Mode:        Single   Switch   Ratio/difference 
---------------------------------------
Targets:     33.5    26.25   0.783582
RT:          20063.8    20036.8   0.998654
Clicks:      34.5    27.75   -6.75
OverClicks:  4    6   2
--------------------------------------

The raw data file looks like this:

subnum,type,trial,width,height,length,sumdist,anglesum,sumoptions,entropy,numclicks,lastclick,rt,time,s001,s002,s003,s004,s005,s006,s007,s008,s009,s010,s011,s012,s013,s014,s015,s016,s017,s018,s019,s020,s021,s022,s023,s024,s025,s026,s027,s028,s029,s030,s031,s032,s033,s034,s035,s036,s037,s038,s039,s040,s041,s042,s043,s044,s045,s046,s047,s048,s049
test,letter,1,7,7,34,37.9706,61,156,9.76244,36,34,20035,21157,1,2,8,9,15,16,22,29,23,17,10,3,4,11,5,6,12,13,7,14,21,28,20,27,19,18,24,31,30,36,43,44,37,38,32,25,26,34,35,41,33,40,39,45,46,47,48,42,49
test,num,2,7,7,32,35.1421,57,156,8.65579,33,32,20090,33554,1,2,8,15,9,16,10,3,4,5,11,17,18,25,19,12,13,6,7,14,21,20,26,27,33,32,24,23,22,30,29,36,43,37,31,39,38,44,45,46,47,40,48,41,34,28,35,42,49
test,numletter,3,7,7,28,30.7279,39,156,8.08556,29,28,20091,22070,1,8,2,3,9,10,4,5,11,17,18,12,6,7,14,13,19,25,24,31,30,23,16,15,22,29,36,37,43,44,38,32,26,20,27,21,28,35,34,33,41,40,39,45,46,47,48,42,49
test,letternum,4,7,7,23,25.7279,29,156,5.56215,24,23,20004,22118,1,2,3,9,8,15,16,22,29,23,17,10,11,4,5,6,12,18,24,30,36,43,44,37,31,25,19,13,7,14,20,26,27,21,28,35,34,33,32,38,45,39,46,47,40,48,41,42,49
test,letter,5,7,7,35,39.799,49,156,10.1624,35,35,20092,22552,1,2,8,15,9,16,22,29,23,17,24,30,36,43,44,37,31,25,18,19,12,11,10,3,4,5,6,13,7,14,20,26,32,38,39,45,46,47,40,33,41,34,27,21,28,35,42,48,49
test,numletter,6,7,7,25,27.3137,46,156,6.16634,29,25,20023,21917,1,8,2,3,9,10,16,15,22,29,23,17,24,25,31,30,37,36,43,44,45,38,32,39,33,26,18,11,4,12,5,6,7,13,19,27,20,14,21,28,35,34,42,41,40,46,47,48,49
test,num,7,7,7,33,38.6274,39,156,9.86663,34,33,20038,21858,1,8,15,9,2,3,10,4,5,11,17,16,23,22,29,36,30,24,18,12,6,7,14,13,19,25,31,37,43,44,38,32,39,45,46,47,40,33,26,20,21,27,28,35,34,42,41,48,49
test,letternum,8,7,7,29,32.5563,53,156,8.00478,29,29,20029,23177,1,8,2,9,3,10,4,5,11,17,16,15,22,23,29,36,30,37,43,44,45,46,38,39,31,24,18,19,12,6,7,14,13,20,26,25,32,40,47,41,33,34,27,21,28,35,42,48,49

You probably just want to analyze sumdist for the different type variables, and you might average pure (num and letter) versus switch (numletter and letternum).