<< Click to Display Table of Contents >> Navigation:  User Guide > Data > Handling data > Data summary report

Companion

From the Main window you can use [Analysis] [Summary report].  You will be asked for a data file to analyse and then be placed at Data summary.

This can also be requested from the Data view window to count the data currently being viewed.

This report is sometimes called a ”top-line” or "frequency" report.

It is useful for checking missing data, see the "Empty column" in the entry list.  It is also useful for checking unusual values in integer and float questions.

This shows a list of entries in the project with the entry text.  The list can be restricted to only those selected on the Main window.

The summary report can be:

•Printed to a printer (or PDF file, with the appropriate driver)

•Output to XML for use with a style sheet, see Reference Manual, Files, Output files

•Output to a file as HTML for use with an internet browser, see Reference Manual, Files, Output files

•Copied to the clipboard for pasting into a spreadsheet program, for example Microsoft Excel

For filters the display shows:

•Base - the number of records (serials) that are true for this filter

For variables and questions it shows:

•Base - the number of records that pass the filters and should have an answer

•Empty - the number of those in the base that are empty (blank)

By selecting an entry from the list you can obtain a list of the various answers given to the question, with a count of the number of times each answer appears in the data.

For single-coded and multi-coded entries, the list shows for each response:

•Count of the number of respondents with this response

•The percentage of the base with this response

•The response number and response text

For other entry types, the list is sorted and shows:

•Count of the number of respondents with this answer

•The percentage of the base with this answer

•The answer text

Empty responses or answers can be suppressed.

A cumulative percentage can be requested to help determine ranges (bands) to be used for later analysis.