mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > CrossTab > 1. How CrossTab Works > 2. Two kinds of questions

CrossTab

2. Two kinds of questions

CrossTab can analyze variables coded from closed-end and open-end questions. In a survey study, for instance, the researcher gathers 315 interviews with a semi-structured questionnaire. Data are edited, coded and inputted in a database of 317 rows and 69 columns that looks like the one below (rows 11-312 and columns F-BL are hidden).

 Pareto Chart,Survey Data Analysis CrossTab Software

In the range A1:BQ317 are stored all data gathered during this hypothetical survey. 315 people were interviewed. The answers of the first interviewed person are in the range A3:BQ3, row 3. The first interview refers to:

  • a man (Sex code 2, column B), who
  • speaks English (Language code 1, column C),
  • belongs to Client Class 1 in our client ranking list (column D), and
  • lives in the North of the country (Region code 1, column E).

Columns A:E in the picture below refer to closed-end questions. This means questions that have all possible answers pre-specified. Closed-end questions that allow single answers only are stored in one single column as, for instance, the variable vector B2:B317. CrossTab recognizes values in first row as titles. Codes can be either numerical or text values, and blank cells are skipped. Every unique code in the variable vector is identified and displayed as a single class in the table. Multiple answers to closed-end questions are treated as described below for open-end questions.

Open-end questions, on the other hand, allow people to answer with their own words. Columns BM:BQ refer to the open-end question Why do you use Swiffer?. Respondent 1 (row 3) answered with two reasons: to Remove dust (cell BM3) and because it does a Quick job (cell BN3). CrossTab requires titles on two rows for open-end questions. The first row hosts the question label (cell BM1) and the second row hosts code labels (BM2:BQ2). Every unique code in the variable vector is identified and displayed as a single class in the table, and blank cells are skipped.

 Pareto Chart,Survey Data Analysis CrossTab Software

Note:
In the range A1:E1 there is text written in a different colour. In fact, this text is only needed when the data set we work with mixes closed- and open-end questions. It is nothing else than a copy of range B2:E2. When working with closed-end data only the grey titles arent needed.

Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: