Excel Tips: Survey data, tables and exporting data to SPSS

Survey Legend
Views: 460
Get Embed Code
Guide to entering survey data and creating cross-tables in Excel 2007. You have distributed and collected survey data using a questionnaire with a number of questions. Now you want to enter the data and create cross-tables in Excel. Eventually you also want to export the raw data into SPSS for further analysis. First you must enter the name of the variables in the first row, then enter the raw data in the following rows. Second, to create cross-tables, select your data (including the first row with the variable names), click on the Insert-tab, click Insert Pivot table, and insert the empty table into the worksheet. From the right side, drag one variable to the rows and another to the columns. Also, drag the last one to the main data field. By default, Excel might work with sums, and that ruins the table. We need to change that, by right-clicking in the main data field and dragging down to Summarise data by and select Count (the table will now show frequencies). To export the raw data to SPSS: Save as an ordinary Excel file. Close the file (or quit excel) and start SPSS. In SPSS, click File, drag down to Open and select Data. Make sure you tell SPSS that you want to open an excel file, else the file will now show up. Once you located the file, open it.

You need to be a member of Land Surveyors United - Surveying Education Community to add thoughts!

Join Land Surveyors United - Surveying Education Community

E-mail me when people leave their comments –

Discover Videos by Type

Educate Future Land Surveyors

Comment as:

β˜…
β˜…
β˜…
β˜…
β˜…
Votes: 0

You need to be a member of Land Surveyors United - Surveying Education Community to add thoughts!

Join Land Surveyors United - Surveying Education Community

Comments are closed.