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)....
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 conditions
at 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.
Have you considered creating a PivotTable to consolidate the data eliminate redundancies?
- I'm happy to consider it, but I'm not experienced at doing so.