User Guide Section 11. Analyzing Your Survey Results

Section 11. Analyzing Your Survey Results

Use this feature to analyze survey results at any time. Create cross-tab charts and banner tabulations. Publish professional reports via Microsoft Word™. Summarize responses for an entire survey or a specific section. Convert responses to other file formats to take advantage of other data analysis applications you have.

Note: In addition to performing the following actions on all based on all of the respondents for a survey, it is also possible to perform the actions on a specific subset of the respondents for a survey. To perform an action on a filtered subset of the respondents for a survey, simply apply a filter via the View Results tab.

Selecting A Survey To Analyze

The Analyze Results tab provides access to features that help you analyze survey results.

Just like the View Results tab, from the Analyze Results tab you initially see the high-level details for your survey. This include the number of respondents, response date ranges and survey description are visible for the currently selected survey.

Step 1 - Select your survey from the Select a Survey prompt.

Note: As you select a different survey, survey summary details are displayed in the area below your selection.

Step 2 - Select an action from the Select an Action to Perform on the Survey Results prompt.

Step 3 - Select Perform Action.

Selecting An Action To Perform On Survey Results

This section describes how to use the various analysis actions.

Converting Responses to Other Data Formats

Performing the Convert Responses action causes all survey responses to be saved in a file with one of the following data formats:

Comma-Separated Values (CSV)
Data Interchange Format (DIF)
Excel (XLS or XLSX, depending upon the system preference)
Hypertext Markup Language (HTML)
SPSS (SAV)
Tab-Delimited Text (TXT)

The file format created depends on which data format you select.

Step 1 - When the Select Data Format window appears, select a data format and a record layout preference.

Step 2 - When the Save As window appears, enter a name for the file you want to create in the File name field.

Step 3 - Select Save to have SurveyGold creates your survey responses in the file format you specified.

Data Layout

One Response Per Record

Each response to a given question appears in one exported row of data. This format is preferable for use with Excel as it lends itself for use by the PivotChart and PivotTable features of Excel.

Data columns

Section
Question
Response
Enumeration (an integer number representing the ordinal value of the response in the set of choices)
Notes/comments
Completed date
Completed time
Web session ID
Respondent ID (a unique integer assigned by SurveyGold to a respondent)
First name
Last name
Organization/company
Title
Address
City
State
Postal code
Phone
Fax
Email address
User-defined custom field 1
User-defined custom field 2
User-defined custom field 3
User-defined custom field 4
Weighting index attribute
Weighting index score
Question number
Question ID (a unique integer assigned by SurveyGold to a question)
Optimal response
Optimal response value
Score (equates to 0 if [Response] does not match the [Optimal response]; equates to [Optimal response value] if [Response] matches the [Optimal response])

One Respondent Per Record

All responses for a given respondent appear in one exported row of data. Each response to a question appears in a different column. This format is preferable for use with SPSS.

Data columns

Respondent ID (a unique integer assigned by SurveyGold to a respondent)
First name
Last name
Organization/company
Title
Address
City
State
Postal code
Phone
Fax
Email address
Completed date
Completed time
Web session ID
User-defined custom field 1
User-defined custom field 2
User-defined custom field 3
User-defined custom field 4
Response (one column for each question)

Creating a Banner Tabulation Report

Performing the Create Banner Tabulation action allows you to create set of a cross-tabular charts that compare the responses between one question and all the other questions in a survey.

Step 1 - When the Create Banner Tabulation window appears, select the question whose responses you want to compare against all other questions.

This question is referred to as the "banner question" because the question and the set of question responses appear as a "banner" horizontally across the resulting set of cross-tabular charts.

Step 2 - Select OK to have SurveyGold create a banner tabulation using the question you specified to compare against all other questions.

Editing All Responses for a Question

Performing the Edit All Responses for a Question action allows you to efficiently edit all responses for a specific question in a tabular presentation style. This is a helpful technique in those situations where you want to add a new question after a survey has been conducted, or when you just want to make edits and revisions to a survey responses.

Step 1 - When the Select Question to Edit window appears, select the question whose responses you want to edit using the list provided.

Step 2 - Select OK to have SurveyGold display a tabular list of respondents with their editable responses for the question you specified.

Creating a Cross-Tab Chart from Any Two Questions

Performing the Graph Cross-Tab Questions action allows you to create a cross-tabular chart from the responses of any to two survey questions. Responses from the first selected question are used to create rows. Responses from the second selected question are used to create columns. The cells that form the intersection of the rows and columns contain a count of the number of responses for that intersection.

Step 1 - When the Select Cross-Tab Questions window appears, select the two questions using the lists provided.

Step 2 - Select OK to have SurveyGold create your cross-tab chart from the questions you specified.