Exceltemplates.org – In marketing world survey is one of the important tools to find out the recent market trend based on the opinion of target market. However, survey is not limited in marketing field but also in research field as well as student assignment that required public opinion. Unfortunately, each person has their own opinion even one question could have different answers from each person that’s why doing survey with essay answer is not recommended because it is not easy to filter or put the answers in the category; that’s why Yes No Chart comes as a handy solution for this situation.
What you need is just the list of questions that you have formulated to represent the whole point of the survey. Perhaps it is the hardest part of the survey because it is not easy to formulate questions with two options of answer only which is Yes or No and at the same time could answer the questions you need for the survey. But it is possible to be done as long as you understand the purpose of the survey and what answers you should obtain.
There are two ways to conduct this kind of Yes No chart survey:
- Online
By doing it online through website and social medial is very easy because the answer could be automatically generated by the system and put the answer in the right category.
- Offline
Though you should do the data input based on the category manually but it is still easier to do as long as the number of question and the number of people to be surveyed or respondents are reasonable enough to be counted manually.
- Direct Interview
Compared to offline, direct interview is much easier because you don’t need to prepare the questions sheet equal to the number of people but you could just prepare it and interview them directly for the answer and you could put the answer directly to the Yes or No sheet to be counted later in the excel spreadsheet.
Once you have collected all the data and then you could start working on the chart. Some points that are supposed to be in the features are:
- The list of questions
The list of question will lead assist you in making the summary at the end of the survey by using the yes or no ratio as the guidelines.
- The number of respondents
The number of respondents will affect the ratio of yes or no answer that later will be used to summary the result of the survey.
- Basic data of respondents
It is actually optional based on the survey you are working on. Basic data is like age and gender because sometimes in marketing field, opinion could be different based on gender and age.
Yes No chart is the easiest solution to gain or obtain information for respondents efficiently and effectively without the need to know their exact opinion because though it is possible to put each person opinion into specific category but still it will take times.