Your last column is the sum of correct answer for every case and you can calculate the percentage of correct answer with that using varfun. Let's say T is your table and now you use varfun to calculate the sum of group_count for every case (true+false). So,
T_percent = varfun(@sum, T, 'GroupingVariables',{'sub_id','condition'});
now the resulting table looks like,
T_percent =
sub_id condition GroupCount sum_answer sum_group_count sum_sum_count
______ _________ __________ __________ _______________ _____________
1_1 1 1 2 1 10 8
1_2 1 2 2 1 10 5
2_1 2 1 2 1 10 7
2_2 2 2 2 1 9 5
3_1 3 1 1 1 10 10
3_2 3 2 2 1 10 4
4_1 4 1 2 1 10 4
4_2 4 2 1 1 10 10
5_1 5 1 1 1 10 10
5_2 5 2 2 1 9 4
6_1 6 1 2 1 8 7
6_2 6 2 2 1 9 4
now, you have to simply calculate the percentage of last column with it's previous column to know the percentange of right answers. So,
T_percent.Percent_True = (T_percent{:,end}./T_percent{:,end-1}).*100;
now the table looks like,
T_percent =
sub_id condition GroupCount sum_answer sum_group_count sum_sum_count Percent_True
______ _________ __________ __________ _______________ _____________ ____________
1_1 1 1 2 1 10 8 80
1_2 1 2 2 1 10 5 50
2_1 2 1 2 1 10 7 70
2_2 2 2 2 1 9 5 55.556
3_1 3 1 1 1 10 10 100
3_2 3 2 2 1 10 4 40
4_1 4 1 2 1 10 4 40
4_2 4 2 1 1 10 10 100
5_1 5 1 1 1 10 10 100
5_2 5 2 2 1 9 4 44.444
6_1 6 1 2 1 8 7 87.5
6_2 6 2 2 1 9 4 44.444
With the last column, you can create a new column for percentage_false case.
Best Answer