I’ve got online responses for my survey in Excel. In the questionnaire, each question has 3 choices of answers (yes=3, no=1, ?=2).
Besides, half of the questions are reversed (yes=1, no=3, ?=2). I need to code answers into points in order to count points for each person in. How do I do that?
Please, can you provide me a detailed explanation? And also afterwards how do I summarize the points for each person and how do I count the average for males and females separately?