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.
| Type | Blue | White | Total |
|---|---|---|---|
| Longboard | 20 | 15 | 35 |
| Shortboard | 5 | 3 | 8 |
| Total | 25 | 18 | 43 |
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 blue boards, are longboards and are shortboards. Divide both counts by . For the white boards, divide by because that is the total for the white column.
| Type | Blue | White |
|---|---|---|
| Longboard | 80% | 83.3% |
| Shortboard | 20% | 16.7% |
| Column total | 100% | 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 longboards. Of those, are blue, so is about . There are shortboards, and of them are blue, so that share is exactly .
| Type | Blue | White | Row total |
|---|---|---|---|
| Longboard | 57.1% | 42.9% | 100% |
| Shortboard | 62.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.
| Type | Blue | White | Total |
|---|---|---|---|
| Longboard | 46.5% | 34.9% | 81.4% |
| Shortboard | 11.6% | 7.0% | 18.6% |
| Total | 58.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.
| Continent | Count | Share of tally |
|---|---|---|
| Europe | 16 | 57.1% |
| North America | 6 | 21.4% |
| Australia | 2 | 7.1% |
| Asia | 3 | 10.7% |
| South America | 1 | 3.6% |
| Total | 28 | 100% |
For more practice reading row, column, and grand totals, see joint, marginal, and conditional distributions.