Hi,
I am having some trouble aggregating data from a survey I created.
There are 5 questions (F, E, N, R, P) which appear 3 times slightly modified. i.e. F1, F2, and F3. The idea is to see if individual's choices change through F1 to F3, E1 to E3 etc. Each time, a person answers "A", "B" or "C". The dependent variable would be a categorical variable (A,B, or C).
I think I should aggregate the responses, create dummy variables for each question type, and create a dummy for version 1,2, or 3.
But I have no idea how I should do this. I have been searching through various commands and forums.
This how the data looks in an Excel document:
I would really apprecaite some help on this. I feel out of my depth.
Thanks,
Tash
I am having some trouble aggregating data from a survey I created.
There are 5 questions (F, E, N, R, P) which appear 3 times slightly modified. i.e. F1, F2, and F3. The idea is to see if individual's choices change through F1 to F3, E1 to E3 etc. Each time, a person answers "A", "B" or "C". The dependent variable would be a categorical variable (A,B, or C).
I think I should aggregate the responses, create dummy variables for each question type, and create a dummy for version 1,2, or 3.
But I have no idea how I should do this. I have been searching through various commands and forums.
This how the data looks in an Excel document:
I would really apprecaite some help on this. I feel out of my depth.
Thanks,
Tash