发新话题
打印

How to get ThesisTools questionnaire data into SPSS

How to get ThesisTools questionnaire data into SPSS

Thesistools is a free survey/questionnaire website that most of the Dutch students use to create their questionaires. Importing yout Thesistools data into Spss can be done by following these steps.
  D- H- o3 ~* \spss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews1.       Go to the ThesisTools website  Modify Questionnaire. Login, click ‘Results’ and download the data as an Excel file.# {& w# \# {8 C, z" F2 S! B5 c3 R
2.       Open the Excel file (if you get a warning, just click ‘Yes’) . Delete the Page, Title and Legend rows.
3 Y! ~/ P' Y( t0 r; `' M$ e0 Ispsschina.cn2 e: [( E5 O6 z4 K5 |% g9 {
3.       Rename what is now the top-left cell (‘Question’) into respondentID (or something like that). Also, you can delete any blank columns. The result is a nice, clean Excel file (see below). Save the file as an Excel (.xls) file . Close Excel.spsschina.cn  i! l' _$ j+ l1 H3 n
4.       Open SPSS  File  Open Data, set “Type of files” to “Microsoft Excel (*.xls)”  and select your Excel file
4 B' [; t; ]1 n' W% F! Vspss论坛|spss下载|spss视频|Amos|SEM|SAS|Matlab|Eviews5.      A dialogue screen will appear. Make sure that “Read variable names from the first row of data” is selected (which it is by default) and click ‘OK’.  SPSS should now have opened your file, which can later save a proper SPSS file (.sav file). For practical purposes, you may want to shorten the labels/names of the variables. You can do this by going to the ‘Variable View’ sheet.

TOP

发新话题