Millisecond Forums

Dear Inquisit Forum,

I was wondering if I could have some help regarding the subject title in question. I have run several Inquisit-powered experiments, and often I spend a few hours after data collection restructuring the data into an easier format to analyse (specifically, trying to restructure long into wide data sets) to calculate average scores and standard deviations.

Please see attached for my script. Essentially, there will be 20 data points per participant. In a 'long' data set, this will obviously mean 20 rows for each participant. As I understand it, this is simply how Inquisit displays your data (however, if there is a way around this, please correct me). However, another way to help with data analysis is for Inquisit to calculate averages and standard deviations as values. 

Essentially, the participant will read a scenario (of which there are 20), either a 'good' version, or a 'bad' version of the scenario. The participant presses the spacebar, and this can produce either a 'good' or a 'bad' outcome to the scenario. Thus, there are four possible combinations between a scenario and an outcome - good(scenario)-good(outcome), good-bad, bad-good, and bad-bad. The participant will then estimate the time interval between pressing the spacebar, and the image appearing. Linking this back to my question, this would then lead to each participant have 4 average time interval estimations (and SDs) - one for each possible combination (e.g., good-good). I could do this in Excel, but I'm not especially apt at restructuring data to do this in less than a few hours.

If anyone has the time to read my script and offer me any advice, I would be very grateful. I apologise in advance if any of my explanation isn't clear.

Best,
Josh