Excel 2007: Survey data, tables and exporting data to SPSS
Loading...
Uploaded by kentlofgren on May 6, 2009
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.
- 23 likes, 2 dislikes
-
- 4:09
Excel 2007: Enkätdata, tabeller och att exportera till SPSSby kentlofgren3,033 views
- 3:21
Word 2007: Page numbers starting from a specific pageby kentlofgren476,457 views
- 1:23
Tutorial for how to write citations . c o mby kentlofgren431 views
- 2:57
Word 2007: Sidnumreringen startar från en specifik sidaby kentlofgren57,410 views
- 5:42
Export data directly into Excel from a web page in IE7by bytebodger18,387 views
- 1:25
How to Enter Data in SPSSby drminaung8,101 views
- 7:37
SPSS Data manipulationby regionomics9,418 views
- 59:00
Webinar: How to Use Excel for Data Analysis and Reports Webinarby APIAHF5,206 views
- 3:43
Excel In Depth - Frequency Distribution: #1258by bjele1239,945 views
- 5:56
YouTube SPSS Lecture Series 1 of 5 - Data Entryby throngle15,553 views
- 8:46
Data Analysis with Excelby WCEastFZX22,472 views
- 2:42
Importing Data from Excel into SPSS/PASWby bernstmj1,806 views
- 4:30
1. Entering Data and Naming Variables.aviby limkianboon2,964 views
- 8:01
Introduction to SPSS 1by JohnMacInnes5642,090 views
- 1:42
Evaluate Survey Data with Microsoft Office Excel 2007.wmvby teachit091,197 views
- 7:41
How to Enter Data into an Excel® 2007 Spreadsheetby videoprofessor7,084 views
- 2:44
Microsoft Excel - Multiple Choice Questionby ismaziz215,214 views
- 3:22
Microsoft Excel 2007 Data Tables 2by NetresultTraining10,407 views
- 3:28
SPSS Data Analysisby regionomics27,171 views
- 1:15
Fast way to create a form/survey/databaseby kangandgeon17,010 views
thank you very much..:-)
mikomiks05 2 weeks ago
This was just what I needed! Thank you so much. Wish I could get it in writing.
Blessed0ne2 4 months ago
Thank you so much my friend!!!!! will be really useful for my project....cheers!!!
wedofunny 6 months ago
0:07 ...profanity? lol joke. thanks alot!
Kittensbane01 7 months ago
THANKS SO MUCH BEEN STRUGGLING TO ANALYSE MY DATA BUT NOW I FEEL ON TOP OF THE WORLD
londonpie72 11 months ago 2
This is amazing. Thank you so much. This has helped me a lot.
Fries4me41 1 year ago
thank you for this tutorial :)
SteveNilson 1 year ago
!!! I like it!
thanhha1985 1 year ago
Thank you..
This video helped me in creating good results TABLES for my Project
sivakumarvideo 1 year ago
Hello, on 2007 Excel i am unable to drag my data into the columns shown during your video 2:30.
Can you please explain to me why ?
Much thanks.
nathanism 1 year ago