Hello everyone, I have a data which has a categorical variable (north/south) and about 10 variables about access to public goods. I want a table that includes the percentage of respondents for each category(north/south) that have access to each of the public goods. For example, take three public goods: piped water, electricity, and tarred road. I want a table that contains the percentage of respondents in categories of north and south that have access to piped water, sewage, and tarred road, separately. To explain further, the table will show what percentage of the respondents surveyed in the north (or south) that have access to piped water. (the same will be done for other variables: electricity grid, tarred road).
I have attached a sample of my data here. Array