Hello, I´ve got a multiple response variable from a survey:
1 "Miradas lascivas (degeneradas)"
2 "Silbidos y otros sonidos (besos, jadeos, bocinazos)"
3 "Acoso verbal (aluciones al cuerpo y de tipo sexual)"
4 "Arcamiento intimidante (tocar cintura, hablar al oido,etc)"
5 "Agarrones (de senos, vulva, trasero, pene, besos a la fuerza)"
6 "Sentimiento de presion"
7 "Persecución (a pie o en medio de transporte)"
8 "Exhibicionismo"
9 "Violación"
10 "Nunca he sido acosada/o"
11 "Otro"
This variable has a multiple response, so there are some respondent who can choose:
1, 2 and 3; or just 1; or 1, 2, 5, 6, 7; or 1, 11 and so on.
My data is in excel and what I want is to split every response in order to create a frequency chart to find how many respondent answer 1; how many 2; and so on
I hope yo can guide me with this
Kind regards
1 "Miradas lascivas (degeneradas)"
2 "Silbidos y otros sonidos (besos, jadeos, bocinazos)"
3 "Acoso verbal (aluciones al cuerpo y de tipo sexual)"
4 "Arcamiento intimidante (tocar cintura, hablar al oido,etc)"
5 "Agarrones (de senos, vulva, trasero, pene, besos a la fuerza)"
6 "Sentimiento de presion"
7 "Persecución (a pie o en medio de transporte)"
8 "Exhibicionismo"
9 "Violación"
10 "Nunca he sido acosada/o"
11 "Otro"
This variable has a multiple response, so there are some respondent who can choose:
1, 2 and 3; or just 1; or 1, 2, 5, 6, 7; or 1, 11 and so on.
My data is in excel and what I want is to split every response in order to create a frequency chart to find how many respondent answer 1; how many 2; and so on
I hope yo can guide me with this
Kind regards
Comment