I am stuck. Please see my question below which I asked during my fieldwork:
Q: For what do you use the water in the tank? [select all that apply]
Answer: 1=gardening, 2= cooking, 3= drinking, 4=washing clothes, 5= cleaning, 6= bathing
When I captured the data onto spss, I've put each question seperate.
E.g in the variable view, the question is: Do you use the water for gardening? Yes = 1, No = 2;
Do you use the water for cooking? Yes=1, No = 2
I would like to present my data in a table format saying " 40% of respondents use rainwater for gardening, 10%drinking ..."
At the moment my tables are for all seperate, I want one table with all 6 variables in a table format.
My question to the forum is: how do I put this into one table using spss?
I hope my question makes sense and that you can help me.
I hope to hear from you soon.