For your second paper, each student will be required to select a database and use SPSS to analyze it. A list of links to possible data may be found on the course web page. SPSS allows several possibilities for creating or importing databases. These include:
1) Create your own data base based on original research material (as we did with the World War I database.
2) Open an already existing SPSS file (as we did with SFWomen). Several existing files may be found in the folder at D:/Program_Files/SPSS10.
3) Import an Excel or other spreadsheet or database file.
4) Import a text file with data.
1) Go to the link on the Web Page for Crime Statistics, 1860-1920.
2) Select San Francisco. Select Excel version of this data (at bottom on table).
3) Either print out the data or write down variable names.
4) Delete the Variable names and all non-data letters from the database.
5) Change all N/A to 999999 or some other numeric data that can be used as a missing value.
6) Save the file as an .xls file. (sfdata) Close that file in Excel.
7) Open up SPSS. Click on the Open File icon and select the drive where the sfdata file is stored.
8) In the dialogue box, select Excel as the file type.
9) Type in sfdata as file name and click OK.
10) The data should now appear in the SPSS Program. Save it as an SPSS file.
11) Go to Variable view and type in the variable names, labels, and other relevant information. Be sure start each variable name except year with the letters sf, i.e., sfdrunk
1) Repeat the process above for the Crime Statistics data for Baltimore. Be sure start each variable name except year with the letters ba, i.e., badrunk.
2) Open the Data Pulldown menu and select Merge Files/ Add Variables
3) Select the sfdata.sav file. Click Ok.
4) At the next dialogue box, click Ok again.
5) You should now have one file containing both sets of data.
1) Go to the link on the Web Page for Age at Death in Edinburg, 1740-1792 .
2) Save the file to your disk as a text file.
3) Open the file in Word. Delete all of the information except the data. Save the file as a text file. Close the file in Word.
4) Open the File in SPSS as a text file. This will open the Text Import Wizard.
5) In the text import wizard, keep clicking Next until your only option is Finish. Now click Finish.
6) Go to Variable view and type in the variable names, labels, and other relevant information.
1) Go to the link on the Web Page for Age at Census Data, 1790-1960.
2) Select a year (We’ll Use 1880 for an example).
3) Select the categories that you wish to look at and highlight them. (We’ll use Population)
5) Click On Browse 1880 data.
6) Highlight the data, copy it and past it into a Word File. Save the file as a text file.
7) Edit the file so as to eliminate all spaces between words, i.e., New York should become NewYork. Also eliminate all commas. Save the file as a text only file and close it.
8) Open the File in SPSS as a text file. This will open the Text Import Wizard.
9) Click Next for Steps 1 and 2.
10) At Step Three, indicate that a specific number of variables establishes a case and indicate that 12 variables is the correct number, then click next.
11) Click Next for steps four and five and then Finish for Step six.
1) Select CSU Data Bank
2) Click on Downloads.
3) Select Censbgatsp.exe-PC
4) Click on it and save the file.
5) Under programs select Winzip and select Winzip 6.3.
6) When that program is open Click on Open and go to Censbgatsp.exe-PC.
7) Click on the file that has been opened. When it asks if you wish to look at it with the default editor say yes. Select SPSS win as the editor to look at it with. It should open up as an SPSS file.
8) The codebook may be found on the download page, or you can run a file info command.