Data summary

<< Click to Display Table of Contents >>

Navigation:  Reference Manual > Windows and dialog boxes > Data summary >

Data summary

From the Main window menu [Analysis] [Summary report] is used to get a "top line" or "frequency" count from a data file.  This can also be reached from the Data view and Data prepare windows.

This has a toolbar:

24FileOpen Open.  Access an existing data file using Open data file.

SelectedOnly Selected.  This only displays entries selected on the Main window.

Refresh Refresh.  You need to do this if you have selected different entries on the Main window to display.

24FileSave To file.  Saves all the counts to a file, see Report file type.

EditCopyAll Copy.  Copy all counts to the clipboard (not just selected items) for pasting into a spreadsheet program, such as Microsoft Excel.

Font Font.  Change the font to use for print and display.

FilePrint Print.  Print all the counts to a printer.

The Data summary dialog box allows you to display summary reports and print them, see User Guide, Handling data, Data summary.

The summary report can be output to a file using Report file type.

You can alter the appearance of the report by cutting and pasting the file to a word processing package.

All records count as 1.  No weighting is available yet.

Title

This shows the title that will be used as a heading for the report.  It can be changed if required.

Entry list

This shows a list of entries with the entry text.

For filters it also shows the number of records (serials) that are true for this filter.

For variables and questions it also shows the:

Base - the number of records that pass the filter 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.

Selected entry counts

When one entry is selected in the entry list, the counts for that entry are shown:

For single-coded and multi-coded entries the list shows:

Count - the number of questionnaires with this response

Extra - the count as a percentage of the base for this question

Text - the response number followed by the response text

For other entry types the list is sorted by answer value and shows:

Count - the number of questionnaires with this answer

Extra - the count as a percentage of the base for this question

Text - the value or text of the answer

The rows are sorted on the answer values in ascending numeric order.  Nonnumeric values are shown first for character questions.

Options

You can select one or more entries in the list and set:

Zero row suppress - empty responses or answers are not shown

Percentages cumulative - the percentage shown is the current answer percentage plus all previous answer percentages; the last percentage shown is therefore usually 100%

The cumulative percentage is useful for integer and float entries to determine the ranges (bands) to be used for later analysis.