December 18, 2012
Molly McPup

Introduction to Research Methods in Political Science:
The POWERMUTT* Project
(SPSS Version)

*Politically-Oriented Web-Enhanced Research Methods for Undergraduates — Topics and Tools
Resources for introductory research methods courses in political science and related disciplines

TABLE
OF
CONTENTS

IV. DISPLAYING CATEGORICAL DATA  

Subtopics

SPSS Tools

  • New with this topic
  • Review

 


Introduction

A picture is said to be worth a thousand words.  Tables and graphs, properly designed, 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 tabular and graphic form.  In later topics, ways of displaying information about continuous variables will be explained.


Frequency Tables

A frequency table (or frequency distribution) displays numbers and percentages for each value of a variable.  It is useful for categorical variables (that is, those with values falling into a relatively small number of discrete categories, such as party identification, religious affiliation, or region of a country) rather than for continuous variables (such as age in years or gross domestic product in dollars). 

The following frequency distribution shows the number of seats in the U.S. House of Representatives by region of the country following the 2000 Census:

Pop Up Protocol (PUP) button

SPSS frequency distribution: region of country

The first column in the table provides a label for each category of the variable.  The second and third columns show, respectively, the number and percent of cases in each category for all cases.  The fourth column shows the percent in each category after eliminating cases for which we do not have information (missing data).  Since we know the location of every congressional district, the fourth column is identical to the third in this case.   The last column shows the cumulative percentages as one goes from the first to the last category.  Note that this last column makes sense only if the values of the variable can be meaningfully ranked.  In other words, cumulative frequencies assume at least ordinal level measurement.  The numbers in this column make no sense in this example, since it wouldn't be meaningful to say that 42.1 percent of seats "are located in the Midwest or less.


Contingency Tables

A contingency table (also called a crosstabulation, or crosstab for short) displays the relationship between one categorical variable and another.  It is called a “contingency table” because it allows us to examine a hypothesis that the values of one variable are contingent (dependent) upon those of another.

The following crosstabulation shows the relationship between region and party affiliation in the House of Representatives following the 2008 elections:

Pop Up Protocol (PUP) button

 

SPSS crosstab: party by region

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 focus on the overall picture.  In this case, the table shows that there are substantial regional differences in party strength.  Don’t get bogged down in the details. 


Making Tables Presentable

The frequency distributions and crosstabs are presented above just as they were generated by SPSS.  This is the way in which tables will normally be presented in POWERMUTT, so that you can run your own analyses and compare your results to what is presented here.  For use in a term paper, however, you will probably want tables that are more aesthetic.  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.  By the same token, a lot of extraneous information has been omitted.  Tables usually present information only for valid cases.  Cumulative percentages are omitted from Table 1, since region is only a nominal variable.  Individual cell counts and row totals are omitted from Table 2, since this information can be reconstructed if needed from the information that is provided.  Ask your instructor whether it will be sufficient to copy and paste tables from SPSS into your word processor or whether you will need more formal tables such as shown here.

Table 1:
Regional Distribution of Seats
in the U.S. House of Representatives

 

 

Seats

Percent

Region

 

 

Northeast

 83

 19.1

Midwest

100

 23.0

South

154

 35.4

West

 98

 22.5

 

 

 

Totals

435

100.0

 

 

 

Source: Office of the Clerk, U.S. House of Representatives, Statistics of the Presidential and Congressional Elections of November 4, 2008.
http://clerk.house.gov/member_info/electionInfo/2008/2008Stat.html. Corrected to July 10, 2009. Accessed August 26, 2010..

 

Table 2:
Party Distribution of Seats
in the U.S. House of Representatives
by Region

 

 

                                                         Region                                                        

 

Northeast

Midwest

South

West

Party

 

 

 

 

Democrat

 81.9%

  55.0%

 45.1%

  64.3%

Republican

18.1

45.0

53.9

35.7

 

 

 

 

 

Totals

100.0%

100.0%

100.0%

100.0%

 N

83

100

154

98

 

 

 

 

 

Source: Office of the Clerk, U.S. House of Representatives, Statistics of the Presidential and Congressional Elections of November 4, 2008.
http://clerk.house.gov/member_info/electionInfo/2008/2008Stat.html. Corrected to July 10, 2009. Accessed August 26, 2010..


Pie Charts

A pie chart is a simple way to show the distribution of a variable that has a relatively small number of values, or categories.  This figure, for example, is a pie chart showing the number of seats held in the U.S. House of Representatives by region:

Pop Up Protocol (PUP) button

Figure 1:
Regional Distribution of Seats in the U.S. House of Representatives


Bar Charts

Another way to portray this kind of information is with a bar chart, as shown in this figure:  

Pop Up Protocol (PUP) button

Figure 2:
Regional Distribution of Seats in the U.S. House of Representatives

 


Key Concepts

bar chart
contingency table
crosstab
crosstabulation
frequency distribution
frequency table
pie chart


Exercises

These exercises use the 2008 American National Election Study Subset. Open the codebook describing these data. Start SPSS and open the anes08s.sav file.

1.  Prepare a frequency table, pie chart, and bar chart for an economic, social, or foreign policy issue of your choosing (see codebook).  Crosstabulate this with several background variables (again, see codebook) that you think might influence a respondent's opinion on this issue. Cautions: 1) avoid background variables like age or income that have a large number of categories. In another Topic, we'll show you how to recode variables like this to make them more manageable; 2) some categories of some background variables contain very few cases, and the results are likely to be unreliable. In another topic, we'll discuss how measures of statistical significance can help you better assess the reliability of findings.

Convert your frequency and contingency tables into presentation-ready form.   

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. Using "partyid3" as the dependent variable, construct contingency tables to test the following hypotheses, along with any others you can think of:

  • Men are more likely than women to identify with the Republican Party.
  • Southerners and midwesterners 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.
  • Respondents from union households are more likely than those from nonunion households 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
Were the results of these exercises pretty much what you expected, or were there any surprises?

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.

Gostats.com, "Graphing and Types of Graphs," GoStats. http://gostats.com/resources/types-of-graphs.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 contingency table analysis .


Except where indicated, © 2003-2012  John L. Korey

Last Updated: December 18, 2012