DISPLAYING CATEGORICAL DATA 
Subtopics

 


Introduction

Tables can provide clear pictures of patterns contained in many thousands of pieces of information. In this topic, we will describe several ways of displaying information about categorical variables.  In later topics, ways of displaying continuous data will be explained.


Contingency Tables

Contingency tables (also called crosstabulations, or “crosstabs” for short) display the relationship between one categorical (usually nominal or ordinal) variable and another.  They are called “contingency tables” because they allow us to examine a hypothesis that the values of one variable are contingent (dependent) upon those of another.

The following crosstabulation shows the relationship, also from the study of American college students, between voting intention in the 2004 presidential election and whether the student was attending a public or a private college or university.

There are several important things to notice about the way in which the table has been set up:

Do not let all the trees get in the way of seeing the forest.  In interpreting a crosstab, it is crucial to look for the overall pattern.  In this case, the table shows that there is virtually no relationship between the type of institution students attend and their voting intentions.  While this is fairly obvious in this case, in viewing a larger table one may become distracted by the details.  Look first for the overall pattern, and don’t allow yourself to get bogged down in the pursuit of trivia. 


Making Tables Presentable

 The crosstab table presented above just as they were generated by SPSS.  For use in your presentation at the end of the term, however, you will probably want tables that are more aesthetically pleasing.  The following tables are a little more presentable, and also contain a bit more information, including 1) a title that briefly describes what the table is about, and 2) the source of the data used to generate the table. While you should do likewise for your presentation at the end of term, it will be sufficient to copy and paste tables from SPSS into your word processor for routine homework assignments. 

Table 1: Perception of Ease of Finding a Job After Graduation
 

N

Percent

Valid Percent

Cumulative Percent

Very easy

48

4.0

4.1

4.1

Somewhat easy

319

26.5

27.2

31.3

Somewhat difficult

652

54.1

55.7

87.0

Very difficult

152

12.8

13.0

100.0

Subtotal

1171

97.2

100.0

 

Don’t Know

34

2.8

 

 

Total

1205

100.0

 

 

         
Source: Harvard University Institute of  Politics, Study of “The Political Personality of America’s College Students,” 2004

 
Table 2: Voting Intention by Type of Educational Institution

 

Public

Private

Vote Intention

 

 

Bush

  44.4%

  44.6%

Kerry

55.6

55.4

 

 

 

Total

100.0%

100.0%

N

399

157

 

 

 

Source: Harvard University Institute of  Politics, Study of “The Political Personality of America’s College Students,” 2004

 


Clustered bar charts are a useful way to provide a graphic display similar to the tabular display in a crosstab.  The chart shown here is equivalent to the contingency table described above.

 


Exercises

1.         Start SPSS .  Open one of the datasets provided, choose some categorical variables, and produce frequencies, pie charts and bar charts.  

2.         In exercise 1 of the “Political Science as a Social Science” topic, you were asked to come up with hypotheses that might help explain party identification.  Start SPSS .  Open the “anes00s.sav” file.  Open the 2000 American National Election Study Subset codebook.  Using partyid3 as the dependent variable, construct contingency tables and clustered bar charts to test the following hypotheses:

·        Men are more likely than women to identify with the Republican Party.

·        Southerners and those from the north central states are more likely than others to identify with the Republican Party; northeasterners and westerners are more likely than others to identify with the Democratic Party.

·        The more education people have, the more likely they are to identify with the Democratic Party.

·        Married respondents are more likely than others to identify with the Republican Party.

·        The more regularly people attend religious services, the more likely they are to identify with the Republican Party.

·        Whites are less likely than others to identify with the Democratic Party.


For Further Study

Energy Information Administration, “Graphs and Charts,” Official Energy Statistics From the Government. I http://www.eia.doe.gov/pub/oil_gas/petroleum/analysis_publications/oil_market_basics/graphs_and_charts.htm.

Harris, Andy “Graphs and Charts,”   Syllabus of CSCI 100.  http://klingon.cs.iupui.edu/~aharris/mmcc/mod6/abss8.html.

Lane, David M., “Describing Univariate Data,” Hyperstat Online. http://davidmlane.com/hyperstat/desc_univ.html.

Math League Multimedia, “Using Data and Statistics,” The Math League. http://www.mathleague.com/help/data/data.htm.

Rosenberg, Scott, “The Data Artist,” Salon.com March 10, 1997.

http://www.salon.com/march97/tufte970310.html.


[1] A more systematic method for assessing the reliability of percentages in a crosstab is discussed under the topic of continency table analysis .