Show

 

 

Approaches to analyzing survey results

 

This topic describes how you can analyze and explore a dataset containing survey results, starting with the simplest approach and then moving to more complex methods.

If you want to know how to import an Excel spreadsheet containing survey results into NVivo, refer to Import data from spreadsheets and text files.

In this topic

 

Explore your survey data in Detail View

When you open the dataset in Detail View, you can visually explore the dataset. When you are working with the dataset in Detail View, you can:

  • Hide columns to limit the amount of data you are looking at—for example, if you want to see the first column in your dataset next to the fifth column, you can hide the intervening columns.

  • Manually code survey responses at nodes representing the themes in your data—refer to Basic Coding in dataset sources for more information.

You can also run queries to find and code at themes in your data:

Top of Page

Gather responses to each question

Do you want to see how all respondents replied to a question? Gathering responses to each survey question at a node allows you to group the data into broad themes.

Using the example dataset below, you could create a node Question 1 and code the entire column at that node. You could create another node to contain all responses to Question 2.

Respondent Age Sex Question 1 Question 2
Anna 29 Female I think there should be more car-free zones Electric buses and taxis would help reduce pollution in the inner city
Jack 31 Male Pedestrians need to feel safe. There should be better lighting and more police We should create more green spaces
Maria 52 Female Safety barriers at busy intersections I don't think they should tax car parks
Peter 47 Male Better education in schools about road safety More street trees

You can code the column manually or automatically:

  • You can select the entire column and manually code it at a new node called Question 1

  • You can use the Auto Code Assistant —select  Code at nodes for selected columns.  This is useful when you have many columns containing responses to different survey questions.

NOTE When each respondent is represented by multiple rows (a row per survey question), you can still use the Auto Code Assistant to gather the responses to a single question at a node—refer to Gather survey responses from multiple rows for more information.

Whichever method you use, you will create and code at the following nodes:

  • Question 1

  • Question 2

Once you have grouped all responses to a question at a single node, you can use some of NVivo's powerful analysis tools, including:

  • Open the node and visually explore content coded at the node.  From here you could 'code on' to more granular thematic groupings. For example, you could gather all answers which mentioned car-free zones.

  • Run a Word Frequency query (using the node in the scope of the query) to find common words or concepts in responses to Question 1.

  • Run a Text Search query looking for particular words or concepts, using the node in the scope of the query. For example, you could search for education and code all the results at a new node.

Top of Page

Gather responses of each survey respondent

If your data contains classifying fields that describe your survey participants—for example, the name, age and sex of the participant—you can use these fields to create nodes that represent your survey participants. You can code everything a participant said in response to survey questions at the node that represents them.

Using the data below, for each respondent you would create one node, of the classification 'person', with attributes for Age and Sex. Responses to both Question 1 and Question 2 would be coded at this node.

Respondent Age Sex Question 1 Question 2
Anna 29 Female I think there should be more car-free zones Electric buses and taxis would help reduce pollution in the inner city
Jack 31 Male Pedestrians need to feel safe. There should be better lighting and more police We should create more green spaces
Maria 52 Female Safety barriers at busy intersections I don't think they should tax car parks
Peter 47 Male Better education in schools about road safety More street trees

Using the NVivo's automated tools, you can do this in two steps:

  1. Code content at nodes for each person.

Use the Auto Code Assistant—select Code at nodes for each value in a column, to code the Question 1 and Question 2 responses at nodes representing the values from the 'Respondent' column. This creates the following nodes:

  • Anna

  • Jack

  • Maria

  • Peter

At this point, the nodes have coding, but are not classified, and have no attribute values.

  1. Add classifying information to the nodes for each person.

In this release of NVivo for Mac, you cannot classify nodes directly from the dataset, however, as a workaround, you can do the following:

  1. In Excel, edit a copy of the file that contains your survey data to delete any columns from the spreadsheet that do not contain classifying information—for example, delete the columns containing responses to questions.

  2. Next, edit the 'Respondent' column in the spreadsheet so that the data matches the full hierarchical name of the nodes in your NVivo project. For example, if after auto coding your dataset, your Nodes folder contains a parent node Survey with a child node Anna, then the full hierarchical name for the child node is 'Nodes\\Survey\Anna'.

  3. Save the Excel spreadsheet as a text or csv file.

  4. In NVivo for Mac, import the text or csv file as a classification sheet—refer to Import (or export) classification sheets for more information.

Once you have created and coded responses at nodes for each respondent, you can use analysis tools which compare their attribute values. You can:

  • Run a Word Frequency query (using the node in the scope of the query) to find common words or concepts in responses to Question 1. You could code the results at new nodes to further refine your analysis.

  • Run a Text Search query looking for particular words or concepts, using the node in the scope of the query. For example, you could search for education and code all the results at a new node.

When you have gathered responses both at question nodes (Question 1, Question 2 ) and at respondent nodes (Anna, Jack, Maria, Peter), you can analyze what respondents in different demographic groups are saying in response to particular questions:

  • Use a Coding query to view all the responses of males  to Question 1.

  • If you save the results of your coding query (above) as a node, you can use a Word Frequency query to find the most commonly occurring words or ideas that males mention when responding to Question 1

NOTE

  • If each respondent is represented by multiple rows (a row per survey question), you can still use the Auto Code Assistant to gather each person's responses at a node—refer to Gather survey responses from multiple rows for more information.

Top of Page

Gather responses based on demographic values

It is possible to create nodes that reflect the demographic characteristics of your respondents—this provides another way of looking at your data.

Respondent Age Sex Question 1 Question 2
Anna 29 Female I think there should be more car-free zones Electric buses and taxis would help reduce pollution in the inner city
Jack 31 Male Pedestrians need to feel safe. There should be better lighting and more police We should create more green spaces
Maria 52 Female Safety barriers at busy intersections I don't think they should tax car parks
Peter 47 Male Better education in schools about road safety More street trees

Using the dataset above, you could use the Auto Code Assistant—select Code at nodes for each row to create nodes to represent the male and female respondents. Responses to survey questions are coded at the appropriate node.

  • Female

  • Male

This can be a quick way to gather responses by demographic groupings. You can see what  all males are saying.

Top of Page

Related topics