Hi,
I have an example enclosed in this post. I would like to calculate the Difference of Scores (Column 4) between Column 3 and Column 2 and then calculate the Mean of that difference per participant (Column 5).
The problem is that I cannot use simply the formula "PostTest - PreTest" because I need to delimit its range (per participant). Furthermore, I have got different numbers of participants because of missing data, so I cannot use simply the formula "Mean(Difference of Scores)".
How can I perform those calculations, please? (In case the solution is more complex please add it in that file, please)
Subject PreTest PostTest Difference of Scores (= PostTest - PreTest) Mean(Difference of Scores)
100 1 5 4
100 3 7 4
100 8 7 -1
100 ... ... ...
100
200 10 10 0
200 9 2 -7
200 6 4 -2
...
Thank you!