Crypto Commerce

How to read two-way tables with overlapping groups

Suppose twelve people are invited to two activities held at different times: a reading circle and a puzzle session. You want to know how many attended either activity, yet some people attended both. To read two-way tables accurately, give each person one place in a grid defined by two questions: Did they attend the reading circle? Did they attend the puzzle session? Then add the appropriate cells for the question you are answering. Adding the two activity totals without accounting for shared attendees would count some people twice.

By Republeq Editorial · 8 min read ·
read two-way tables: A person holds a blue counter above round and square counters on a wooden desk beside an open notebook.

Suppose twelve people are invited to two activities held at different times: a reading circle and a puzzle session. You want to know how many attended either activity, yet some people attended both. To read two-way tables accurately, give each person one place in a grid defined by two questions: Did they attend the reading circle? Did they attend the puzzle session? Then add the appropriate cells for the question you are answering. Adding the two activity totals without accounting for shared attendees would count some people twice.


This is a fictional exercise, with complete attendance known for all twelve people. It is about distinct people, not the number of visits. Someone who came to both activities still contributes one person to the combined headcount. If you are working with actual attendance information, establish what is known about each activity before placing anyone in a cell.


Before Bar Chart Planning, Separate The Four Groups


Imagine a list with exactly one record per invited person. For each record, the answer to each attendance question is explicitly yes or no. The two activities took place at separate times, so a person could have attended either, both, or neither. These conditions produce four possible combinations. Each combination belongs to one interior cell of the table, and each person belongs to exactly one of those cells.


Here is the entire fictional roster, arranged by its two answers. The names make it possible to check the counts against actual individuals rather than relying on a total that only looks plausible:


  • Reading circle yes, puzzle session yes: Ada, Ben, and Cora. Cell count: 3.
  • Reading circle yes, puzzle session no: Dev, Eli, Fran, and Gus. Cell count: 4.
  • Reading circle no, puzzle session yes: Hana and Ira. Cell count: 2.
  • Reading circle no, puzzle session no: Jo, Kai, and Luz. Cell count: 3.

The first cell means both activities, while the next two mean exactly one activity. The last cell means neither activity. A yes in the reading-circle row alone tells you only half the story; you must also look at the puzzle-session column to decide whether the person attended both or reading circle only. Likewise, someone in the puzzle-session yes column might have attended the reading circle as well. Read the row and column labels together before interpreting a number inside the grid.


One way to picture the table is to put reading-circle attendance in the rows, with yes above no, and puzzle-session attendance in the columns, with yes to the left of no. The upper-left intersection then holds the three people who attended both. The upper-right holds the four who attended only the reading circle. The lower-left holds the two who attended only the puzzle session, and the lower-right holds the three who attended neither. Reversing the order of rows or columns changes where the numbers appear, but it does not change which people each labeled intersection represents.


Notice the difference between a cell and an activity total. The count of 3 for the yes/yes cell is exclusive: it names just Ada, Ben, and Cora. The count of 7 for reading-circle attendance, which you can write at the end of the yes row, includes those three people plus Dev, Eli, Fran, and Gus. The count of 5 for puzzle-session attendance, which you can write beneath the yes column, includes Ada, Ben, and Cora plus Hana and Ira. A marginal total collects multiple cells; it is not another independent group of people.


If you read two-way tables by checking only the margins, the overlap is easy to miss. Here, the activity totals are 7 and 5. Their sum is 12, which happens to equal the size of the entire roster. That apparent agreement is a coincidence: the three people counted twice across the two activity totals are balanced by the three people counted in neither activity total. The matching numbers do not mean that all twelve people attended something. The four interior cells, rather than the coincidental sum of the margins, show what happened.


Try pointing to a person before pointing to a total. Cora appears in the yes/yes cell once. She belongs to the reading-circle total and the puzzle-session total, so those two margins each include her. Jo appears in the no/no cell once and in neither activity total. When the question changes from attendance at a particular activity to the number of distinct people who attended at least one, the same table must be read differently. No one needs to be moved; only the selection of cells changes.


Bar Chart Planning Needs A Count With One Meaning


Start with the wording of the question. “How many attended both?” asks for the yes/yes cell: 3. “How many attended either activity?” asks for everyone with at least one yes: 3 from both, 4 from reading circle only, and 2 from puzzle session only. Those cells sum to 9 distinct people. The word “either” can be ambiguous in ordinary conversation, so say “at least one activity” when you mean to include people who attended both.


“How many attended exactly one activity?” excludes the shared cell. Add the 4 who attended only the reading circle and the 2 who attended only the puzzle session, giving 6. “How many attended neither?” is the no/no cell alone: 3. These questions sound similar, yet they select different areas of the grid. Writing the selected cell names beside an answer is a quick way to make your meaning visible to someone checking the result.


There is another useful check on the combined headcount. Add the count for at least one activity, 9, to the count for neither, 3. The result is the complete twelve-person roster because those two groups leave no one out and share no one. You can also add all four interior cells: 3 plus 4 plus 2 plus 3 equals 12. If either check fails when the roster is supposed to be complete, revisit the cell assignments or arithmetic before reporting a headcount.


The two activity totals can still help answer the combined question if you account for the overlap. Seven reading-circle attendees plus five puzzle-session attendees gives twelve activity memberships. Ada, Ben, and Cora each contribute two memberships, although each is one person. Remove one extra count for each of those three people, and the distinct headcount becomes 9. This is why the reading-circle total plus the puzzle-session total does not directly answer “How many people attended at least one?” The margins count membership in each activity; the combined question counts individuals.


It helps to test the method with one name from every cell. Ben contributes to both activity totals but once to the at-least-one group. Eli contributes to the reading-circle total and once to the at-least-one group. Ira contributes to the puzzle-session total and once to the at-least-one group. Kai contributes to neither activity total and does not enter the at-least-one group. Each person still occupies only one interior cell throughout. That fixed placement is what lets you answer several questions without rebuilding the attendance record.


Someone may ask for “people who missed the reading circle.” That wording selects the reading-circle no row, including Hana and Ira, who attended the puzzle session, as well as Jo, Kai, and Luz, who attended neither. Its count is 5. By contrast, “people who missed both” selects only the no/no cell and has a count of 3. The second attendance label matters even when the first part of a question sounds complete. Read the full question before picking a row, a column, or an individual cell.


A blank attendance answer creates a different problem. Suppose a thirteenth fictional person, Mira, is recorded as having attended the reading circle, while puzzle-session attendance is left unresolved. Mira might belong in yes/yes or yes/no, but the known information does not establish which. Do not treat the blank as a no. You can still say that Mira attended the reading circle; you cannot use this incomplete record to decide the count for both activities or exactly one activity. Keep the twelve-person completed example separate while the thirteenth record remains unresolved.


In a real exercise, even the label “neither” requires an explicit no for each activity within the defined roster. Absence from an activity list by itself may reflect an incomplete record rather than confirmed nonattendance. If an attendance answer is unknown, keep that uncertainty visible and resolve it before publishing a four-cell table as complete. The table explains observed combinations only as well as its underlying yes/no answers allow.


Once you have chosen a precise count, bar chart planning can be a separate next step if you want to visualize a clearly named group. Decide whether the proposed figure would show the four exclusive cells or the two overlapping activity totals, and label it accordingly. The attendance question comes first; a visual display cannot decide for you whether “either” includes the shared group.


Tiburn TE-QS1M-75 For A Shared Reading Check


For individual preparation, a laptop can be a place to write the two attendance questions and the four cell counts before a discussion. Republeq lists a Dell Inspiron with a 15.6-inch FHD touchscreen, 16GB RAM, and a 256GB SSD. It is an optional device for someone who wants to read two-way tables on their own screen; the listing does not establish that any particular table-making application is included. A sheet of paper works for this small example, too.


For a group conversation, the listed Tiburn TE-QS1M-75 is described as a 75-inch interactive board intended for collaborative spaces. A group could use a suitable display to examine the labeled intersections together, but check the exact listing for the presentation setup you need. Nothing in this example assumes that the board connects to the Dell laptop or that they share software.


Ask each person in the discussion to name the cells they would count for one question before giving an answer. Someone saying 12 for “at least one” may be adding the activity totals and counting Ada, Ben, and Cora twice. Someone saying 6 for the same question may have silently excluded them. The four-cell roster lets the group locate either mistake without debating a bare number. Finish by checking that the exclusive cell counts account for every person whose attendance at both activities is known.

How to read two-way tables with overlapping groups