Survey Analysis

All reports are created and displayed by the word processor. You have complete control over changing fonts, copying, pasting, spell-checking, alternate row shading, changing column widths, print previewing, printing, etc.

keyword phrase report

The All Questions analysis calculates complete totals of all responses to most questions (not memo field). Additional options can provide calculated averages for numerical questions.

The One Question analysis provides totals for a selected question.

Cross-Tabulation shows relationships between answers made for two survey questions. Responses from two questions are displayed in a pivot table. Choices for the first question provide the table row information. Choices for the second question provide the table column information. Charts can also be created to show the relationships between the selected survey questions.

Cross-Tabulation Banners shows relationships between answers made for a main survey questions and other selected questions. Choices for the first question provide the table row information. Choices for the other questions provide the table column information. These results are displayed like a spreadsheet. Printed reports are formatted for regular letter size paper.

Cross-Tabulation Statistics displays statistical patterns between two survey questions. These statistics are used to determine how these series of numbers for the two questions are distributed. Up to 15 user-selected statistical values can be displayed in the reports, including Number of Values, Maximum, Minimum, Range, Sum, Sum of Squares, Mean, Mode, Median, Standard Deviation, Skew, First Quartile, Third Quartile, and Number of Null Values.

The Filtered Matches provides totals based on how a selected question is answer. For example, if a question asked for either a male or female response, the filtered analysis will show results of how either all males or females answered the rest of the questions. The 6 extra data fields (user's name, email address, User IP address, or user-defined fields) can also be used in the filtered analysis. Multi-filtering allows up to 5 levels (questions and extra data fields) to be examined for matches when creating survey results. Demographic question analysis is often performed by use of these filters.

The Keyword Phrase analysis provides totals for a selected group of questions. For example, a complete survey may ask questions about different committees in an organization. By using keywords, only those questions related to a specified committee would be displayed and included in the reports.

The Text Frequency analysis includes responses to all response questions.

Many program options are common to many program screens. Common chart options are explained in the Chart Editor section. Common report options are explained below. Unique screen settings are described with the specific help file page.

Calculation Details:

Automatic Calculation
If checked, and the question number and positions are valid, the analysis is automatically performed when the survey analysis selection is chosen from the main menu.

Include No Responses in Calculations
If checked, an extra column will be added to the reports to indicate the number of respondents that did not answer the question. The No Response totals would also be included in the percentage calculations.


Include Multiple Choice Text
If checked, the most common text responses for Multiple Choice-Other question type is included in the text analysis. Text responses can have up to 240 characters.

Include Multiple Scale Detail
If checked, percentages are included with the Multiple Scale question type results.

Include Rank Order Detail
If checked, the number of responses to each level of a ranking question are included in the analysis.

Decimal Places for Percentages
The number displayed next to the spinner determines the number of decimal places (up to 4) displayed for percentages on the reports and HTML pages. Decimal places for statistics, ratings, and rankings are set with preferences.

Two Column Scale Detail
If checked, the number of responses for each level of each scale of the 2-Column-Scale questions are included in the analysis.

Maximum Unique Text Responses
The number displayed next to the spinner determines how many (up to 100) of the most common text responses are listed when a Text Response question is analyzed. To list all responses use the Analysis Menu - Text Responses selection.

Common Report Details:

HTML Background Color
If checked, the color selected on the Preferences Menu will be used. If unchecked the HTML background will be white.

Alternate Row Shading
If checked, the headings are shaded gray, and alternate rows of data are shaded with light yellow and white on a light yellow background. If this is unchecked the HTML pages are displayed with a white background, and no shading. The reports will also include a 10% gray shading if checked.

Include All Report Grid Lines
Horizontal and vertical lines can be included on the reports, to make it easier to view text choices and columns of data. If checked the main lines are included in the display and printed reports. See Show All Grid Lines to reveal hidden lines used to change column widths.

Show All Grid Lines
Some lines separating columns are hidden. These grid lines allow you to change the column widths for each question. After changing the column widths, You can remove the lines with the checkbox on each report screen, so they do not print in your final reports. The setting for Include All Report Grid Lines determines if the grid lines are included on the printed reports.

Changing Column Widths
If the report columns are too narrow (or too wide) to display your survey data properly, the column widths can be changed. Place your cursor to the side of the column you wish to resize, then slowly move it until the cursor changes to a sizing arrow. Click the mouse button and hold it down. Still holding the mouse button down, drag the cursor to the left or the right to increase or decrease the width of the column.

Include Blank Line After Question Responses
If checked, and extra blank line is inserted after each question and survey results for each set of responses.

Use Bold Font for Report Column Headings
If checked the column headings will use a bold font on the analysis reports.

Include Letters with Report Text Choices
If checked, letter choices are included with the text choices in the reports.

Include the 3 User Codes with Analysis Reports
The 3 user code fields can also be added to each set of survey responses. This information can be used for frequency and filtered analysis. This information can also be entered when recording responses from a paper survey, revising the current database, and importing records into the database.

Include Question Statistics
If checked, a statistical analysis is performed on the survey results. The following statistics are calculated and displayed: Number of Values, Maximum Value, Minimum Value, Range, Sum, Sum of Squares, Mean, Mode, Median, Variance, and Standard Deviation. Statistics are not calculated for the 3-Column Compare, Open-Text entry, and Date Entry question types. Since this calculation takes additional time, the setting is not saved with other preferences. It is only active for the current session.

Common Report Buttons:

Many buttons on the different screens perform the same function on the different report screens. These buttons are explained. Buttons unique to one screen, are described with the specific help file page.

The Clear button will clear all calculated results from memory, clear the displayed report, and reset the spinners to question number 1..

After selecting the analysis to perform, click the Calculate button. To view the displayed report, click on the View Report tab.

The Questions button will display a complete listing of all questions, the associated question type, choices, report settings, and related information. The report settings can be used to create report templates.

Buttons located on the toolbar are used to control the analysis report. The "Save HTML" and "Print HTML" buttons are only used for the HTML report.

The Print button will print the displayed HTML analysis. If an analysis is not displayed, the print button will not be enabled. The report analysis is printed by selecting the print button from the toolbar.

Print Preview will display the report page(s) prior to printing. When the preview is displayed, you can select from these options: Show Full-Page, Fit-to-Width, Show 2 Pages, Zoom In, Zoom Out, Previous Page, Next Page, Print, SetUp Printer, and Exit. Text Hints are displayed if you pause the mouse cursor over the icon buttons.

Clicking the Help button will display this help file information.

Clicking the OK button will leave the analysis screen, returning to the opening program screen.

Page last updated: January 26, 2008