Forum Discussion
consolidating data from many rows per subject into medians and means per variable in a single row
Hi gang, I have 64 rows of measurement data (reaction time, decision accuracy, memory recall accuracy) for 30+participants with 3 manipulated test variables (high/low, 1/2/3/4, difficult/medium)....
Hi Patrick2788 ,
Is there an option in here to attach a .xls file or do I need to cut and paste into a table within the chat?
You may post into a message here if you like. Several sample rows would be great.
- This helps. Looking at this example, what's the desired result for 516288?
ideally I’m trying to get to a single row for each participant with a mean time for each of the manipulated trial conditions (e.g. a cell/column for median time for WM_load Low, then WM_Load High, then for Visualisation_Grouped, Numeric and so on.
I’m also trying to combine all of the binary accuracy values into a %correct cell/column for each of the manipulated trial conditionsat the end, I would like to have just a single row for each subject.
There are currently 34 subjects each with 64 rows of data that match the different combinations of the three variables.