Viewing Survey Results

From qualtrics

---

Revision as of 11:24, 18 March 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.

Contents 1 View reports 1.1 Stats 1.2 Graphs and Tables 1.3 Report Options 2 Responses 3 Download data 3.1 Excel download 3.2 SPSS download 4 Cross tabulation

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

Coming soon ...

Graphs and Tables

Coming soon ...

Report Options

Coming soon ...

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.

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 versions earlier than 16.0, the Qualtrics Tutorial instructions and Classic Download method should be followed. Variable names in SPSS will still appear as V1, V2.
• 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