Land Surveying Video Guides

SURVEYING TUTORIALS SURVEYING LECTURES SURVEY MAPPING SURVEY MAPS AUTOCAD EXCEL PROGRAMS SURVEYING HOW TO SURVEYING FUNNY BOUNDARIES LAND SURVEYORS SURVEYING PROFESSION TOTAL STATIONS GPS SURVEYING GIS DRONE SURVEYING SURVEYING BASICS SURVEY MONUMENTS

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

GEO Ambassador
Posted by Skip Farrow on February 25, 2019 at 10:05am
Views: 497
Get Embed Code
Tags: tables, exporting, data, surveying, tutorial
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 –
Follow

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

Discover Videos by Type

  • Tags
  • Surveyor Support Videos
  • Surveying Tutorials

Find Surveying Videos By Subject Tag

Choose Your Video Category

Educate Future Land Surveyors

  • +
  • Add Your Surveying Videos
  • Add Survey Videos to Hubs

Comment as:

  • Comment
  • Disqus
  • Your FB Page
★
★
★
★
★
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.