How to Break Down Categorical Statistics Using Two-Way Tables - dummies

# How to Break Down Categorical Statistics Using Two-Way Tables

You can break categorical data down using two-way tables (also known as contingency tables, cross-tabulations or crosstabs) to summarize statistical information about different groups. Categorical data (also known as qualitative data) capture qualities or characteristics about an individual, such as a person’s eye color, gender, political party, or opinion on some issue (typically using categories such as Agree, Disagree, or No opinion, or some variation of these).

Categorical data tend to fall into groups or categories pretty naturally. “Political party,” for example, typically has four groups in the United States: Democrat, Republican, Independent, and Other. Categorical data often come from survey data, but they can also be collected in experiments. For example, in an experimental test of a new medical treatment, researchers may use three categories to assess the outcome of the experiment: Did the patient get better, worse, or stay the same while undergoing the treatment?

Categorical data are often summarized by reporting the percentage of individuals falling into each category. For example, pollsters may report political affiliation statistics by giving the percentage of Republicans, Democrats, Independents, and Others. To calculate the percentage of individuals in a certain category, find the number of individuals in that category, divide by the total number of people in the study, and then multiply by 100%. For example, if a survey of 2,000 teenagers included 1,200 females and 800 males, the resulting percentages would be (1,200 ÷ 2,000) ∗ 100% = 60% female and (800 ÷ 2,000) ∗ 100% = 40% male.

You can break down categorical data further by creating something called two-way tables. Two-way tables are tables with rows and columns. They summarize the information from two categorical variables at once, such as gender and political party, so you can see (or easily calculate) the percentage of individuals in each combination of categories and use them to make comparisons between groups.

The U.S. government calculates and summarizes loads of categorical data using crosstabs. Typical age and gender data, reported by the U.S. Census Bureau for a survey conducted in 2009, are shown in this table. (Normally age would be considered a numerical variable, but the way the U.S. government reports it, age is broken down into categories, making it a categorical variable.)

U.S. Population, Broken Down by Age and Gender (2009)
Age Group Males % Females % Total %
Under 5 10,887,008 7.19 10,412,648 6.69 21,299,656 6.94
5–9 10,535,900 6.96 10,073,734 6.48 20,609,634 6.71
10–14 10,222,522 6.75 9,751,042 6.27 19,973,564 6.51
15–19 11,051,289 7.30 10,486,548 6.74 21,537,837 7.02
20–24 11,093,552 7.32 10,446,007 6.72 21,539,559 7.02
25–29 11,115,560 7.34 10,562,159 6.79 21,677,719 7.06
30–34 10,107,974 6.67 9,780,629 6.29 19,888,603 6.48
35–39 10,353,016 6.84 10,185,335 6.55 20,538,351 6.69
40–44 10,504,139 6.94 10,487,466 6.74 20,991,605 6.84
45–49 11,295,524 7.46 11,535,568 7.42 22,831,092 7.44
50–54 10,677,847 7.05 11,083,544 7.13 21,761,391 7.09
55–59 9,204,666 6.08 9,770,360 6.28 18,975,026 6.18
60–64 7,576,933 5.00 8,234,990 5.29 15,811,923 5.15
65–69 5,511,164 3.64 6,273,156 4.03 11,784,320 3.84
70–74 4,082,226 2.70 4,925,521 3.17 9,007,747 2.93
75–79 3,149,236 2.08 4,176,292 2.68 7,325,528 2.39
80–84 2,298,260 1.52 3,524,074 2.27 5,822,334 1.90
85–89 1,266,899 0.84 2,395,498 1.54 3,662,397 1.19
90–94 424,882 0.28 1,077,381 0.69 1,502,263 0.49
95–99 82,135 0.05 319,842 0.21 401,977 0.13
100+ 8,758 0.01 55,266 0.04 64,024 0.02
Total 151,449,490 100.00 155,557,060 100.00 307,006,550 100.00

You can examine many different facets of the U.S. population by looking at and working with different numbers from the table. For example, looking at gender, you notice that women slightly outnumber men — the population in 2009 was 50.67% female (divide total number of females by total population size and multiply by 100%) and 49.33% male (divide total number of males by total population size and multiply by 100%). You can also look at age: The percentage of the entire population that is under 5 years old was 6.94% (divide the total number under age 5 by the total population size and multiply by 100%). The largest group belongs to the 45–49 year olds, who made up 7.44% of the population.

Next, you can explore a possible relationship between gender and age by comparing various parts of the table. You can compare, for example, the percentage of females to males in the 80-and-over age group. Because these data are reported in 5-year increments, you have to do a little math in order to get your answer, though. The percentage of the population that’s female and aged 80 and above (looking at column 7 of the table) is 2.27% + 1.54% + 0.69% + 0.21% + 0.04% = 4.75%. The percentage of males aged 80 and over (looking at column 5 of the table) is 1.52% + 0.84% + 0.28% + 0.05% + 0.01% = 2.70%. This shows that the 80-and-over age group for the females is about 76% larger than the males (because [4.75 – 2.70] ÷ 2.70 = 0.76).