Show us why the public should always call a land surveyor

Where are you surveying?

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

GEO Ambassador
Views: 497
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 –

Add Survey Videos to Hubs

Did you know that Hubs have videos too?  If you would like a more targeted audience for your videos, you can share your videos inside hubs based on any surveying topic, type of equipment or location.

Comment as:

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

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

Join Land Surveyors United - Global Surveying Community

Comments are closed.

Add Your Surveying 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.

Discover Videos by Type