On Mar 19, 2018, at 2:26 PM, Dan Brooks <dan at brooksbaseball.net> wrote:
Your message formatting was lost when you sent to the list, but you can probably just
aggregate(Response~Participant+Week,data=mydata,FUN=sum)?
-Dan
On Mon, Mar 19, 2018 at 3:18 PM, Katherine Gordon <mnkatie at gmail.com <mailto:mnkatie at gmail.com>> wrote:
Hello all,
I?m trying to restructure my data so that instead of each item having its own row, I have a sum of all of the responses per participant per condition appearing in each row. Basically, I want to create this new format because I want to compare and contrast what the analysis and results look like if you use linear mixed-models vs. traditional ANOVA analyses.
So currently I have the variables Participant, Item (1-6), Week (1,2), and Response (correct or incorrect).
The data is organized as below.
Participant
Item
Week
Response
1
1
1
1
1
2
1
0
1
3
1
1
1
4
1
0
1
5
1
0
1
6
1
0
2
1
1
0
2
2
1
1
2
3
1
1
2
4
1
1
2
5
1
1
2
6
1
0
etc
I would like the data to be organized as the following. Obviously the item column doesn?t need to exist, but wanted to show what I was going for.
Participant
Item
Week
Response
1
1-6
1
2
2
1-6
1
4
etc
Is there a way to create a new data file with the restructured format without having to add the responses for each participant within each condition myself?
Thanks,
Katie
[[alternative HTML version deleted]]