Viewing Survey Results

From qualtrics

Revision as of 11:05, 8 October 2010

Summary of surveys started and completed appears on the “View Results” tab or through “Results” icons

Clicking the Stats link in the upper right hand corner of the View Reports page will give descriptive statistics on

• survey completion times,
• question completion percentages
• the time of day surveys were completed.

Reports Basics

(not available for all accounts)

To view a summary of surveys started and completed, click on the “View Results” tab or the “Results” icon next to your survey in “My Surveys”.

1. View Reports: You will see basic descriptive statistics or text responses for each question and simple charts that are automatically generated by Qualtrics. You can click “Add Graph” or “Add Table” to view your responses in multiple ways. These graphs, tables, and charts can be exported to Microsoft Word, Excel, PowerPoint, and Adobe PDF. You can generate a link to a public report that updates whenever new data is received.
• Clicking the “stats…” link in the upper right hand corner will give descriptive statistics on survey durations, start times and dates, question completion percentages, and survey completion percentages.
2. Responses: You will have access to each individual respondent’s data on this page. Each response will be marked with a start time, finish date, and duration. You can mark responses for deletion or to retake the survey. You can also view selected responses side-by-side for comparison.
3. Download Data: Data can be easily downloaded to Excel or SPSS for analysis by clicking on the appropriate icon. The default Excel data format is comma separated values (.csv). Also available in XML and HTML formats.
4. Cross Tabulation: Cross Tabs allow you to see the relationship between two categorical variables. Chi-square and p-values are generated.

View reports

You will see basic descriptive statistics or text responses for each question and simple charts that are automatically generated by Qualtrics. These tables and charts can be downloaded to Word or PowerPoint.

Stats

Overall stats appear to the right in toolbar. Click “Stats…” to see more detailed info.

The "Stats…" link gives you information on each survey taker’s duration, start time, start date, question response rates, and survey completion rate.

Reports

If you would like to see the report Qualtrics generates for you, click Initial Report.

In the Qualtrics Report, you will see your list of questions in the left hand column and the data from those questions summarized in the main area of the screen. By default, only one question’s results appears on the screen. You can change this by clicking on Report Options and click on Questions per Page

By default, questions are summarized in tables: one describes each choice and one provides descriptive stats. You can add custom graphs to visualize the data.

Filtering and Subgroups

To add a subgroup to your report,

• Click "New subgroup" in the "Show Filters" section above the list of questions on the left
• Click "sdd a subgroup to this report" at the top of the report.
• Click on one of the answer choices itself - an automatic subgroup will be formed with that answer choice as a filter.

To remove the filter, click the "x" in the red box at the top of the report.

Graphs and Tables

Add graphs by clicking on icon to right of question. There are many graph and table options to choose from. If you hover over the graph or table, a menu will show the options available. You can export your graphs and table for easy access in the following formats: Word, Powerpoint, and PDF.

Report Options

Export Report: Reports can be downloaded in several formats

• Word
• PowerPoint
• Excel
• PDF

Public Reports

Your report can also be made publicly viewable. Qualtrics provides a link for you. You can customize who has access to this page. The report updates in real time.

Responses

You will have access to each individual respondent’s data on this page. Each response will be marked with a start and finish date. You can mark responses for deletion and then permanently remove them from the data set.

It is recommended to use "Delete all Survey Test" and "Delete all Survey Preview" Responses before distributing the survey

Download data

Data can be easily downloaded to Excel or SPSS for analysis by clicking on the appropriate icon. The initial data format will be .csv. Depending on which versions of Excel and SPSS you are using, you may need extra steps for the data to be placed in individual columns or for variable names to be added to the columns

Excel download

In versions earlier than 2007, you will need to specify that it is a comma delimited file for data to appear properly in the spreadsheet

• If data are mainly in text format, viewing result in Excel will be difficult.
  • To get a cleaner look at the data, setting up a Word document with mail merge is a good option
  • Reads data from relevant columns and then puts them into a Word document that is much easier to read.

SPSS download

• In version 16.0, click Download an SPSS Sav File. Variable names will still appear as V1, V2 in the header of your dataset when you are in data view.
• The simplest steps for getting your variable names into SPSS are
  1. Download data to Excel
  2. Copy Row 2 of the data worksheet that has your variable names
  3. On a new worksheet and column, Paste Special
  4. In the Paste Special menu select “Transpose”
  5. Variable names will now appear in a vertical column instead of as one row
  6. Copy this column from Excel
  7. Paste column into the “Name” column of the SPSS Variable View tab
  8. Variable names will now label columns in the Data View tab
  9. WARNING: In order for this method to work seamlessly, labels created in Qualtrics MUST conform to the variable-naming requirements of SPSS
     1. Variable names can be up to 64 characters long, and the first character must be a letter or one of the characters @, #, or $.
     2. Subsequent characters can be any combination of letters, numbers, nonpunctuation characters, and a period.
     3. Variable names cannot contain spaces
• Variable names can also be changed using SPSS syntax
  1. Follow the Download an SPSS .sav file link in Qualtrics. (Data, variable labels, and value information is put into SPSS BUT the variable names still appear as V1, V2 etc. )
  2. Follow the Download Syntax file link through Qualtrics
  3. Open syntax in SPSS
  4. In the syntax file, Change VARIABLE LABELS to RENAME VARIABLES
  5. Change standard syntax from V1 “ResponseID” to (V1=ResponseID)
  6. Complete text change for all variables
  7. Delete everything else below the variable renaming commands except for the final 3 lines of syntax (. CACHE. EXECUTE.)
  8. Select RUN ALL from the SPSS menu
  9. Variable names will switch from V1 etc to the proper names

Cross Tabulation

Coming soon....