Analyze Results

[ Home ] [ Table of Contents ] [ Overview ] [ Setup Survey ] [ Setup Respondents ] [ Fine Tune Survey ] [ Conduct Paper Survey ] [ Conduct Phone Surveys ] [ Conduct Web Survey ] [ View Results ] [ Analyze Results ] [ Share Survey ]

Use this feature to analyze survey results at any time. Find out how to create cross-tab charts. Publish professional reports via Microsoft Word™. Summarize responses for an entire survey or a specific section. Save responses to other file formats to take advantage of other data analysis software tools you have.

• 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 - Click OK to begin the selected analysis action.

   

• Selecting An Action To Perform On Survey The Results

  This section describes how to use the various analysis actions.
  

   

  • Convert Responses

Selecting this action causes all survey responses to be saved in a file with one of the following data formats:

• Data Interchange Format
• dBase
• Excel
• Hypertext Markup Language (HTML)
• SPSS
• Text

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 - Click "Save". SurveyGold then creates your survey responses in the file format you specified.
	Step 4 - Open the file using the software of your choice (e.g., Excel, SPSS.) Normally you can select the file from your Recent Documents menu item from the Windows Start menu.

 

Record Layout Preferences

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 are as follows: 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
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 are as follows: 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)

 

• Graph Cross-Tab Questions

Selecting this 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 Question" window appears, select the two questions using the lists provided.
	Step 2 - Click "OK". SurveyGold then creates your cross-tab chart from the questions you specified.

 

Note: Right-click on the chart to display a popup menu with the following options: Select Cross-Tab Questions - Allows you to specify another set of questions Print - Allows you to print the cross-tab chart Print Setup - Allows you to specify printer preferences Save As - Allows you to save the displayed data to a file in one of several formats including Excel, dBase, text, HTML, and more.

• Graph Section

Selecting this action allows you to create a graph from the results of any section of the selected survey. This graph is most helpful when every question in the section has the same set of choices.

	Step 1 - When the "Select Section" window appears, select the section to graph using the list provided.
	Step 2 - Click "OK". SurveyGold then creates your graph from the section you specified.

 

Note: Right-click on the graph to display a popup menu with the following options: Select Another Section - Allows you to specify another section to graph Change Graph Type - Allows you to specify one of several graph types including bar, column, line, pie and area graphs Print - Allows you to print the section graph Print Setup - Allows you to specify printer preferences Save As - Allows you to save the displayed data to a file in one of several formats including Excel, dBase, text, HTML, and more.

• List Completed Questionnaires

Selecting this action displays completed survey questionnaires for the selected survey.

Step 1 - SurveyGold creates a list of all the completed questionnaires.

 

Note: Right-click on the list to display a popup menu with the following options: Next Page - Allows you to scroll to the next page Previous Page - Allows you to scroll to the previous page Print - Allows you to print all completed questionnaires Print Setup - Allows you to specify printer preferences

 

• List Respondents

Selecting this action displays a tabular list of respondents that submitted responses to the selected survey. The list includes respondent data such as name, title, organization/company, address, phone, fax, email, etc.

	Step 1 - SurveyGold creates a list of all respondents for the survey.
	Step 2 - (Optional) Click on a respondent's name to drill-down to view their completed questionnaire.

 

Note: Right-click on the list to display a popup menu with the following options: Next Page - Allows you to scroll to the next page Previous Page - Allows you to scroll to the previous page Print - Allows you to print all completed questionnaires Print Setup - Allows you to specify printer preferences Save As - Allows you to save the displayed data to a file in one of several formats including Excel, dBase, text, HTML, and more.

 

• List Results

Selecting this action allows you to create a tabular chart of results to all questions from the selected survey. This summary chart shows each question and counts the number of times a particular response occurs.

Step 1 - SurveyGold creates a tabular list of the survey results.

 

Note: Right-click on the chart to display a popup menu with the following options: Sort Responses By Original Sequence - Displays results in the order the choices were displayed to the respondent Sort Responses By Frequency - Displays results with the most frequently provided responses appearing first Next Page - Allows you to scroll forward to the next page Previous Page - Allows you to scroll back to the previous page Print - Allows you to print the section graph Print Setup - Allows you to specify printer preferences

 

• List Scores

If you have accessed the Setup Scoring feature in the Setup Survey tab, selecting this action allows you to create a tabular chart of scored exams. The scores are derived from the individual point values and optimal responses you assigned to each question as they compare to the individual responses submitted.

	Step 1 - SurveyGold creates a tabular list of the respondent scores for a survey.
	Step 2 - (Optional) Click on a respondent's name to drill-down to view their completed scored questionnaire.

 

Note: Right-click on the graph to display a popup menu with the following options: Sort By Last Name - Displays respondent scores in order of the respondent's last name Sort By First Name - Displays respondent scores in descending order Next Page - Allows you to scroll forward to the next page Previous Page - Allows you to scroll back to the previous page Print - Allows you to print the section graph Print Setup - Allows you to specify printer preferences Save As - Allows you to save the displayed data to a file in one of several formats including Excel, dBase, text, HTML, and more. Click on a respondent's name or score to view their scored questionnaire.

 

• List Weighting Index

When a weighting index is assigned to the selected survey feature, this report for an individual or set of respondents multiplies the relative importance of a attribute against the score awarded to a question addressing that attribute. The result is a new view of survey results that gives consideration to relative importance of the attributes you have defined.

The weighting index analysis can be displayed on an individual respondent basis or on the basis of all survey responses by simply right-clicking in the displayed report and selecting the preference via the popup menu.

The formula used to derive the weighting index for a given attribute is as follows:

    weighting index for attribute  =  score  x  attribute weight

The weighting index report can be printed by right-clicking and selecting Print from the popup menu.

 

• Publish Web

Selecting this action produces a formal report of survey results as a set of Web (HTML) documents and associated program and graphics files in a specified folder. The entire contents of the specified folder are intended to be accessed via a web site or a network folder for viewing by a community of interest. SurveyGold uses your graph preferences (e.g., bar, pie, line, etc.) from the View Results feature to produce graphs of each set of question responses. SurveyGold can optionally omit graphs thereby producing a tabular chart of response frequencies for each question. View a sample of the Web report.

	Step 1 - When the "Save Survey Report As Web" window appears, select a folder and enter a name for the file you want to create in the "File name" field. Note: SurveyGold deletes all files with a .HTM, .GIF or .JS file name extension in the folder that you specify. Therefore, it is not necessary to save your files into an empty folder.
	Step 2 - Click "Save".
	Step 3 - When the "Publish Survey Results Using Web Pages" window appears, specify your publishing preferences.
	Step 4 - Click "OK". Then SurveyGold creates your report and opens your browser to display it.

• Publish Word

Selecting this action produces a formal report of survey results as a Microsoft Word™ document. Note: This action is only available if Word is installed on your computer. View a sample of the Word report.

	Step 1 - When the "Save Survey Report As File" window appears, select a folder and enter a name for the file you want to create in the "File name" field.
	Step 2 - Click "Save".
	Step 3 - When the "Publish Survey Results Using Word" window appears, specify your publishing preferences.
	Step 4 - Click "OK". Then SurveyGold creates your report and opens Word to display it.

 

Continue on to the next section: Share Your Survey