How do I automatically rearrange data located in Microsoft Excel?

October 27, 2013
Pinterest Stumbleupon Whatsapp

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?

Ads by Google