Preparing Data for Analysis and Triangulation

children with "thinking caps" on their heads
••• Andrew Rich / Vetta Collection / Getty Images

Market researchers prepare qualitative data from surveys, interviews, and focus groups for analysis and triangulation. They create tables containing all of their retrieved data to analyze and capture demographic information that may be important to the study. For example, it is useful to highlight the criteria used to select the study participants, as these attributes can be important to the analysis.

The criteria or attributes are the basis for identifying key sort categories.

At this stage of the data table preparation, it is helpful to think about the information that will be key to the data retrieval when data tables are merged. Consider the many conditions for which data analysis will be made easier and more accurate by merging tables:

  • Multiple respondents⁠—study participants
  • Focus groups⁠—several respondents
  • Study data from different time periods
  • Data grouped by question type across respondents

Adding Columns to Tables

So far, the data table would show these columns from left to right: Participant Name or ID, Theme Code, Moderator Questions/Participant Response, and Sequence

The next columns to be added would show selection criteria or participant attributes.  For example, a researcher may wish to sort participant responses by their role in an organization, by age, or by gender. The text in rows containing questions asked by interviewers or moderators should be bold, so they stand out visually from the responses of study participants.

It is helpful to format the table in landscape view by adding columns for pertinent criteria or attributes that will extend the width of the table considerably. 

Using Short Labels for Key Sort Categories

Sort categories can be represented by numbers, letters, or number-letter combinations. Rather than writing out the sort categories in full words, a researcher may choose to use short tags.

  For example, organizations are different orchestras around the world. The orchestras can be matched with short tags as follows:

  • Simon Bolivar Youth Orchestra = S
  • Youth Orchestra of Los Angeles (YOLA) = L

The roles of individuals in the organizations can also be coded:

  • Conductor = 1
  • Concert Master - 2
  • Musician = 3
  • Music Teacher = 4
  • Festival Director = 5

The market research budget of a small business owner or, especially, a home-based business generally does not have room for spending large sums on software to analyze the qualitative data collected for business development. Therefore, you can create a table using an ordinary word processing application to conduct text analysis for qualitative market research.  The processes described can be applied to the analysis of quantitative data collected from surveys research, focus group sessions, and in-depth interviews