Excel: evaluate the questionnaire - how it works
You can evaluate a questionnaire relatively easily with MS Office Excel. In this practical tip, we will show you exactly how this works.
Evaluation: Insert questionnaire results in Excel
In order to evaluate the questionnaire, you first have to import the results into Excel. There are several possibilities for this. We'll show you one of them.
- Open a new document in MS Office Excel.
- Now create a type table in which you list the results. For example, write the participants (Person1, Person2, Person3, ...) in a column and the possible answers (Answer1, Answer2, Answer3, ...) in one line. To make the table clearer, you can design the table with a right click -> "Format cells".
- Now mark the answer for each person with a "1". You can simply leave out omitted answers.
- Repeat these steps for all questions on the questionnaire.
Evaluate questionnaire results in Excel
After you have inserted the results in Excel, you can evaluate them. As always, there are various options in Excel.
- To count the number of answers selected, click in the respective cell below the table. Click on the "Function catalog" in the top bar and select the "SUM" function. Now mark all columns of the first answer. Press the Enter key to complete the process. Excel now counts how many people chose the answer. Repeat this step for the other answers.
- You can also view the results visually on a chart. To do this, simply mark the line with "Answer1, Answer2, Answer3, ..." and then hold down the Ctrl key and the previously created totals of the answers. Now click on "Charts" in the menu bar and select a pie or bar chart. This is then created and you can visually evaluate the questionnaire.