Customer Service: +44 1334 657957

Companion Data handling user guide

This section shows examples of the Companion main window and some associated dialog boxes:

The data check dialog box enables you to inspect a data file for specific errors. You should check a data file before running any analysis. The checking is done in two or three phases:

Phase 1 (Open data file). This phase only deals with structural problems and only cleans data that is not recognisable for the type of question. It does not check filters or variables.

Phase 2 (Check data). This phase is used to check the data file against the questions and filters in the project and report any errors. This is sometimes called a ”report edit”.

Optional phase 3 (Clean and check data). This is identical to Phase 2, except that the answers are cleaned. This is sometimes called a "force edit".

Optional phase 4 (Save data).

The data view window is used to view and edit the contents of a data file, showing the answers to each question for each questionnaire. The data is listed in a data grid with a row for each serial and the entries as the columns. Any questions that had an error during checking are marked.

The weight data window is used to open a data file and calculate the respondent weights needed to achieve the targets set.  The targets can be simple grossing up or down, full matrix, rims, accumulated quantity targets, or any combination of these.

The window has three areas:

Weight statistics - This area shows the results of the calculations, so far, for each target set.

Data - This shows the respondent data being used for the weighting, including the calculated weights and the target entries.

Other - Here you can choose the precision required for the calculated weights, which is set as significant digits. This area also shows the average and worst target significant digits achieved for any target set.

The weight targets window is used to select entries to be used for the weighting targets. The list of entries chosen is shown, along with their targets set.

The weight save dialog box appears when the weight data window is closed, and lists information (targets, statistics, project with weight entry added, weights and serial numbers, and data with weights added) that can be saved from the weighting procedure.

The data export dialog box takes you through the four stages used to output data to a spreadsheet report (CSV or XML):

Data: choose the data file to extract the report from

Filter: choose the records to use in the report

Output: choose the types of output to use in the report

Entries: choose the entries to output

When all the relevant sections have been completed, the report is displayed in a raw CSV file view window, and it can be saved to a file.

The export type user control is used to control export reports created with the Data export dialog box.

The serial number select dialog box appears when you add a new record from the Data view window.

The open data file dialog box is used whenever you need to open a data file to check, view, update, weight or produce an analysis report.

The data ready list dialog box shows a list of all data files previously accessed in this session and all data files with recognisable extensions in the project directory.

The data prepare window enables you to combine one or more data files for analysis, and has an option to filter the combined file on a sub-set of the questionnaires.

The filter definition dialog box is used when a filter definition to define a subset of the records is needed.