Logged In Land Surveyors Do Not See Ads

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

Survey Legend
Views: 346
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 - Global Surveying Community to add thoughts!

Join Land Surveyors United - Global Surveying Community

Votes: 0
E-mail me when people leave their comments –

Logged In Members Do Not See Ads

Comment on this Surveying Video Using:

You Are Not Logged In

Land Surveying Videos Collective

Add or Embed a Land Surveying Video

Add Videos

Sharing your videos and those surveying videos you think will be helpful to other members of the community is incredibly simple.

Upload your Video to the community and describe the video and why you think it is useful to the community.  Use the Rich Text description area to link to more resources.

Embed a video that you found elsewhere from Youtube, Vimeo, etc.

Hey there!
It looks like you are enjoying the community content.

That's nice! Please don't forget to mention us if you use what you just copied on your website. Help strenthen the community by linking back to us!

Thank you very much! Have a nice day! :)

Ok. Don't bother me again, for this session.