To Activities

LSP 121 -- Activity 5

Crosstabs with SPSS

  1. Create a Crosstabs Table on the Excel file MCIC-SMOKE.xls on Older Data page of the QRC Website qrc.depaul.edu. To find this dataset, look at the bottom of the Excel Files page, and click on the link OlderData under Additional Directories.

  2. This file consists of the 1993 and 1997 responses for the question "Do you smoke now?" (SMOKE) along with a set of demographic variables: age (AG), race/ethnicity (RACETH), income level (INC4GP), religious affiliation (REL1), educational level (RESPED), and gender (SEX01), Note that the 1993 and 1997 data are on separate pages; there is also a code page that tells you what the codes mean. Familiarize yourself with the codes.

  3. Import the 1997 spreadsheet into SPSS.

  4. In the Variable View, add a label for SMOKE, SEX01 and the other variable that you select below for your crosstabs table.

  5. In the Variable View, add a value for each value of the variables SMOKE, SEX01 and the other variable that you select below. The values for SMOKE might be 1="Smokes", 2="Does Not Smoke", 7="Refused". The values for SEX01 might be 1="Male", 2="Female", 7="Refused".

  6. We would like to find out what percentage of men smoked and what percentage of women smoked in the sample in 1997. The results should produce a diagram that looks something like this:

      Men Women Total
    Smoke 20 25 45
    Not Smoke 80 125 205
    Total 100 150 250

    Notice how the numbers add up going down and going across. Using SPSS, create a crosstab and print the results.

    See Part J of the SPSS Tutorial for directions on how to create a crosstabs table.

  7. Now create a new crosstabs table that compares the smoking rate to a different variable of your choice. For example, which race/ethnicity smokes or does not smoke? Or which income level smokes or does not smoke? Select one of the other variables and produce a crosstab comparing that variable to smoking.

  8. Export your output to an MS-Word file, delete everything except the crosstabs table, type the names of the persons in your group at the top, and submit it.