Relative Frequency Tables

Student Summary

Converting two-way tables to relative frequency tables can help reveal patterns in paired categorical variables. Relative frequency tables are created by dividing the value in each cell in a two-way table by the total number of responses in the entire table, or the total responses in a row or a column. Depending on what patterns are important, different types of relative frequency tables are used. To examine how individual combinations of the categorical variables relate to the whole group, divide each value in a two-way table by the total number of responses in the entire table to find the relative frequency.

For example, this two-way table displays the condition of a certain textbook and its price for 120 of the books at a college bookstore. 

$10 or less more than $10 but less than $30 $30 or more
new 3 9 27
used 33 36 12

A two-way relative frequency table is created by dividing each number in the two-way table by 120 because there are 120 values (3+9+27+33+36+12) in this data set. The resulting two-way relative frequency table can be represented using fractions, decimals, or percents. so inexpensive and that 10% of the books in the bookstore are both expensive and in used condition.

$10 or less more than $10 but less than $30 $30 or more
new 0.025 0.075 0.225
used 0.275 0.300 0.100

This two-way relative frequency table allows you to see what proportion of the total is represented by each number in the two-way table. The number 33 in the original two-way table represents the number of used books that also sell for $10 or less, which is 27.5% of all the books in the data set. Using this two-way relative frequency table, we can see that there are very few (2.5%) new books that are al

In other situations, it makes sense to examine row or column proportions in a relative frequency table. For example, to convert the original two-way table to a column relative frequency table using column proportions, divide each value by the sum of the column. 

$10 or less more than $10 but less than $30 $30 or more
new 0.083 0.2 0.692
used 0.917 0.8 0.308

This shows that about 91.7% (333+330.917\frac{33}{3+33} \approx 0.917) of the books that are sold for $10 or less are in used condition. Notice that each column of this column relative frequency table reveals the proportions of the books in each price category that are in each condition and that the relative frequencies in each column sum to 1. In particular, this shows that most of the inexpensive and moderately priced books are used, and most of the expensive books are new.

Visual / Anchor Chart

Standards

Addressing
HSS-ID.B.5

S-ID.5

S-ID.5

S-ID.5

HSS-ID.B.5

S-ID.5

S-ID.5

S-ID.5

HSS-ID.B.5

S-ID.5

S-ID.5

S-ID.5