Millisecond Online Community

Hi,

our lab is trying to rearrange some dot probe data collected using the web version of Inquisit. For each participant, there are five practice trials and two blocks of 48 trials each (96 total trials). We need to reformat the data so that for each participant there is a row containing the id, the date, trial-latency, and trial-correct measures for each trialcode. For example, the trial code "neut_left_happy_right_probe_right_BLACK_MALE"  for the first block would look like this:
id    date          neut_left_happy_right_probe_right_BLACK_MALEblock1LATENCY  neut_left_happy_right_probe_right_BLACK_MALEblock1CORRECT         

So far, all we've been able to do is cut and paste to rearrange the data in this order in an excel file but this is incredibly inefficient. If anyone has any suggestions, they would be greatly appreicated. Thanks for your time!

Hi there,

Do you have access to SPSS? If so, the SPSS scripting language has facilities for doing this sort of thing. If memory servers, the AGGREGATE command allows you to collapse data into a single row of summary scores.

Our IAT page has an SPSS script that does this sort of thing for IAT data. You might be able to adapt is to yours. The script can be downloaded from here: http://www.millisecond.com/download/samples/v3/IAT/default.aspx

-Sean