I have a dataset of participant IDs that has one column indicating whether the response is pre or post, and another column indicating the score. Each participant ID has two entries, one pre and one post. Can I merge these into one record based on the participant ID in order to ready it for a paired t-test? So in the end, I would have half the number of records as before but add a new column?
This is what I have: Current
And this is what I want: Desired *note I forgot to delete the pre/post column here but it should be deleted.
Alternatively, if there's a way to do a paired t-test in this format, I would love to know! Thanks!
