Getting the results

collate and analyse data | collate and analyse questionnaire results | present your results

How to analyse questionnaire responses

If the group used an online survey, the software will automatically collate the data – someone will just need to download the data, for example as a spreadsheet.

If the group used a paper questionnaire, someone will need to manually transfer the responses from the questionnaires into a spreadsheet. Put each question number as a column heading, and use one row for each person’s answers. Then assign each possible answer a number or ‘code’.

Go through each respondent’s questionnaire in turn, adding in the codes. Enter this data into a spreadsheet. See below for an example of what this might look like.

Once the group has entered the data from all the questionnaires into a spreadsheet, it is a good idea for someone else to check some of the data for accuracy. If there are many errors, consider checking more of the data.

When the group is happy that all the data is present and correct, calculate how many people selected each response. The young researchers could count this up manually, but it is easier to let the spreadsheet do the work, by adding a filter to each question within the spreadsheet.

Once the group has calculated how many people selected each response, the young researchers can set up tables and/or graph to display the data. This could take the form of a table or chart, for example:

If there are enough questionnaires, the group could look at whether there is any variation in the way that different types of people responded. For example, they might look at just the girls’ responses, compared to just the boys’ responses. If you have a small number of questionnaires, be wary of doing sub sample analysis because the results are likely to be misleading.

Once the young researchers have analysed all the data, they should discuss what story the data is telling, and what it means in terms of the research questions.