How to make a relative frequency table from counts

A table of counts tells us how many are in each group. When we want to compare shares, the question tells us which total to divide by. We’ll use one table to see how the answer changes depending on what we’re comparing.

The shortboard shares in the video’s example are exactly 62.5% blue and 37.5% white. The table below keeps both to one decimal place.

Start with the counts and totals

Suppose Ricky’s surf shop has blue and white surfboards in two lengths. Add across each row and down each column to find the totals. There are 43 boards altogether.

Surfboards by length and color
TypeBlueWhiteTotal
Longboard201535
Shortboard538
Total251843

A relative frequency is a count divided by a relevant total. We can write it as a fraction, a decimal, or a percentage. The phrase “out of all” helps us identify which total belongs in the denominator.

Divide by a column total to compare types within a color

Out of the 25 blue boards, 20 are longboards and 5 are shortboards. Divide both counts by 25. For the white boards, divide by 18 because that is the total for the white column.

2025=0.80,525=0.20
Percentages within each color
TypeBlueWhite
Longboard80%83.3%
Shortboard20%16.7%
Column total100%100%

So 80% of the blue boards are longboards. Each column has its own denominator, so the percentages add to 100% down each column, apart from any rounding.

Divide by a row total to compare colors within a type

Now start with all 35 longboards. Of those, 20 are blue, so 20/35 is about 57.1%. There are 8 shortboards, and 5 of them are blue, so that share is exactly 62.5%.

Percentages within each surfboard type
TypeBlueWhiteRow total
Longboard57.1%42.9%100%
Shortboard62.5%37.5%100%

Each row adds to 100% here. If a row or column has a total of zero, its within-group percentages are undefined because we would have to divide by zero.

Divide by the grand total to compare with all boards

To find what share of all boards are blue longboards, use all 43 boards in the denominator. The result is about 46.5%. Do the same for every cell and for the row and column totals.

Percentages of all 43 surfboards
TypeBlueWhiteTotal
Longboard46.5%34.9%81.4%
Shortboard11.6%7.0%18.6%
Total58.1%41.9%100%

The four inside percentages describe groups that don’t overlap and together account for the whole shop. Small differences in a sum can come from rounding the displayed values.

Use the same idea for a one-way table

In a historical tally of 28 Summer Olympic Games, Europe hosted 16. Europe’s share of this tally is 16 out of 28, or about 57.1%. The other continents use the same denominator.

A historical tally of 28 Summer Olympic Games
ContinentCountShare of tally
Europe1657.1%
North America621.4%
Australia27.1%
Asia310.7%
South America13.6%
Total28100%

For more practice reading row, column, and grand totals, see joint, marginal, and conditional distributions.