Hello everyone
I have a question
I have a survey I made in Excel.
I need to find the percentage of this survey and graph it.
However, there is a different situation. Some questions are "positive", some are "negative".
sample survey question “shoes satisfaction survey” (total number of participants 18)
Yes No
question 1 - does it smell? 10 - 8
question 2 - is it easy to clean? 15 - 3
Those who said yes to the first question said yes to a "negative" situation for this shoe.
however, those who answered yes to the second question said yes for a "positive" case.
In this way, there are 20 different questions.
Based on these data
% pleased
% not glad
I need to find a ratio.
(Considering the positive and negative question)
After doing this I need to show it in graph.
can you help me?
Sorry for my English (Google Translate)