Two Way Tables

Understanding Two Way Tables

A two way table is a grid that organises data into rows and columns, showing frequencies for two categorical variables simultaneously. Each row represents one category of the first variable, and each column represents one category of the second variable.

The cells inside the table show the frequency (count) of occurrences for the combination of categories from the row and column. Totals are usually given for each row and column, summarising the total frequencies for each category separately.

For example, a two way table might show the number of students who prefer different sports (rows: Football, Tennis, Swimming) split by gender (columns: Boys, Girls).

Filling Two Way Tables

When given partial data, you can fill in missing frequencies by using the row and column totals. The totals help check that the numbers add up correctly.

To find a missing frequency in a cell:

• If the row total and all other cells in that row are known, subtract the sum of the known cells from the row total.
• If the column total and all other cells in that column are known, subtract the sum of the known cells from the column total.

Always ensure that the sum of the cells in each row equals the row total, and the sum of the cells in each column equals the column total.

For instance, if a row total is $50 - 30 = 20$, the missing cell must be 20.

For example, if a row total is $40$ and the known cells in that row add up to $25$, the missing cell is $40 - 25 = 15$.

Using Two Way Tables for Probability

Two way tables are useful for calculating probabilities related to two events. The frequencies can be converted into probabilities by dividing by the total number of outcomes (the grand total).

Types of probabilities from two way tables:

• Joint probability: The probability of two events happening together, found by dividing the frequency in the relevant cell by the total number of outcomes.
• Marginal probability: The probability of a single event occurring, found by dividing a row or column total by the grand total.
• Conditional probability: The probability of one event occurring given that another event has occurred. Calculated by dividing the joint frequency by the marginal total of the given condition. This can be expressed as $P(A|B) = \frac{P(A \cap B)}{P(B)}$, meaning the probability of event A given event B.

Probabilities can be expressed as fractions, decimals, or percentages.

For example, if 12 students like football and are boys, and there are 60 students in total, the joint probability that a randomly chosen student is a boy who likes football is $\frac{12}{60} = 0.2$ or $20\%$.

Interpreting Two Way Tables

Two way tables help compare categories and identify relationships between events.

By examining the frequencies and probabilities, you can determine which categories are more common, whether events are independent or related, and solve probability problems.

For example, if the probability of being a girl who likes tennis is much higher than being a boy who likes tennis, this suggests a relationship between gender and tennis preference.

Summary of Key Points

• Two way tables display frequencies for two categorical variables in rows and columns.
• Row and column totals help find missing frequencies and check data consistency.
• Probabilities can be calculated from frequencies: joint, marginal, and conditional probabilities.
• Probabilities are expressed as fractions, decimals, or percentages.
• Interpreting two way tables helps identify relationships and solve probability problems.