Constructing Variables to Make Analysis Easy

From Q
Jump to navigation Jump to search

In addition to the Basic Workflow For Checking and Cleaning a Project, it is also useful to create certain types of variables up-front that will facilitate additional analysis.

Pick One – Multi (e.g., likert scales, importance ratings)

Questions which contain ratings (e.g., ratings of importance, agreement, satisfaction) should be initially setup in Q as Pick One – Multi questions. It is often useful to have a number of additional variants of the data, such as numeric variables for computing means, and variables containing Top 2 Box Scores and separate versions of each individual item in the scale.

The most straightforward way to create such variables is usually as follows:

  1. Type the words create new variables into the Search features and data box in the top right of the Q window.
  2. Select the desired option from the QScripts and Rules section of the results. Commonly-useful options to choose are:

To get a more in-depth understanding, refer to the Online Training tutorial on Multiple Response Questions.

Number - Multi (sets of related numeric variables, such as consumption by brand)

Where Number - Multi questions have a small number of unique values, it is often useful to copy them and also represent them in a way that makes the categories visible. This can be done by:

Ranking questions

It is often useful to represent ranking data in multiple ways (e.g., percentages, top 3 ranks, means). See How to Analyze Ranking Data for detail on how to achieve this.

Grid questions

It is often useful to have two different version of Pick Any - Grid and Number - Grid questions: one version where the missing values are set at their defaults (i.e., people have missing values for options not seen) and another where the missing value are unchecked (if and as appropriate). For example, if the grid question shows occasions that different brands are consumed, and an earlier question in the study was used to filter which brands were shown in the grid question, it would be appropriate to un-check the missing values.

Coding text data

Importing coded data

Where coding has been done in another program, the best approach is usually to have it added to the data file. If you have the data in a different data file, the best approach is usually to:

  1. Get both data files as SPSS .sav data files. Note that if you have the data as a CSV or Excel file, you can convert it to an SPSS file using Tools > Save Data as SPSS/CSV File.
  2. Merge the data (see Merge Data Add Variables).
  3. Import the data into Q.

Often, coded data is not entered in the standard format for Pick Any data, so it is necessary to set its Question Type to Pick Any - Compact (see also Multi-punch/Multiple Response Questions Displaying as Grids).

Performing coding within Q

See Coding.

See also