5/30 FA 9.3 Two Way Tables

Last updated over 2 years ago

33 questions

Note from the author:

OBJECTIVES & STANDARDS
Math Objectives
Identify different types of data, including categorical, numerical, discrete, and continuous.
Summarize categorical data using two-way tables
Interpret data in relative frequency tables in context, including identifying associations.
Common Core Math Standards
Link to all CCSS Math
CCSS.PRACTICE.MP2
CCSS.PRACTICE.MP4
CCSS.HSS.ID.B.5
CCSS.HSS.ID.C.9
Personal Finance Objectives
Analyze real-world data about education and employment
National Standards for Personal Financial Education
Earning Income
3a: Evaluate the costs and benefits of investing in additional education or training
3c: Compare earnings and unemployment rates by level of education and training
DISTRIBUTION & PLANNING
Distribute to students
Student Activity Packet
Application Problems

Instructions

OBJECTIVES & STANDARDS
Math Objectives
Identify different types of data, including categorical, numerical, discrete, and continuous.
Summarize categorical data using two-way tables
Interpret data in relative frequency tables in context, including identifying associations.
Common Core Math Standards
Link to all CCSS Math
CCSS.PRACTICE.MP2
CCSS.PRACTICE.MP4
CCSS.HSS.ID.B.5
CCSS.HSS.ID.C.9
Personal Finance Objectives
Analyze real-world data about education and employment
National Standards for Personal Financial Education
Earning Income
3a: Evaluate the costs and benefits of investing in additional education or training
3c: Compare earnings and unemployment rates by level of education and training
DISTRIBUTION & PLANNING
Distribute to students
Student Activity Packet
Application Problems

Intro

Learn It 1

Practice It

Explore It

Learn It 2

Application

5/30 FA 9.3 Two Way Tables

Last updated over 2 years ago

33 questions

Note from the author:

OBJECTIVES & STANDARDS
Math Objectives
Identify different types of data, including categorical, numerical, discrete, and continuous.
Summarize categorical data using two-way tables
Interpret data in relative frequency tables in context, including identifying associations.
Common Core Math Standards
Link to all CCSS Math
CCSS.PRACTICE.MP2
CCSS.PRACTICE.MP4
CCSS.HSS.ID.B.5
CCSS.HSS.ID.C.9
Personal Finance Objectives
Analyze real-world data about education and employment
National Standards for Personal Financial Education
Earning Income
3a: Evaluate the costs and benefits of investing in additional education or training
3c: Compare earnings and unemployment rates by level of education and training
DISTRIBUTION & PLANNING
Distribute to students
Student Activity Packet
Application Problems

Instructions

OBJECTIVES & STANDARDS
Math Objectives
Identify different types of data, including categorical, numerical, discrete, and continuous.
Summarize categorical data using two-way tables
Interpret data in relative frequency tables in context, including identifying associations.
Common Core Math Standards
Link to all CCSS Math
CCSS.PRACTICE.MP2
CCSS.PRACTICE.MP4
CCSS.HSS.ID.B.5
CCSS.HSS.ID.C.9
Personal Finance Objectives
Analyze real-world data about education and employment
National Standards for Personal Financial Education
Earning Income
3a: Evaluate the costs and benefits of investing in additional education or training
3c: Compare earnings and unemployment rates by level of education and training
DISTRIBUTION & PLANNING
Distribute to students
Student Activity Packet
Application Problems

Intro

ANALYZE: Prom Decisions
The senior class at Evergreen High School is planning their prom! The prom planning committee decides to survey the class on their top options. They ask each senior whether they would prefer to hold prom at Sunset Lodge or the Aquarium and whether they prefer a Under the Sea or Starry Night theme.
Some of the survey results are:
The survey included 92 different students.
20 students said they’d prefer Starry Night at the Aquarium.
43 students said they’d prefer Sunset Lodge over the Aquarium.
47 students said they’d prefer Under the Sea over Starry Night.
18 students said they’d prefer Under the Sea at Sunset Lodge.
Use the above information to answer the following questions. Show all reasoning.

How many students prefer the Aquarium over Sunset Lodge?_______ 
How many students said they prefer both Under the Sea and the Aquarium?_______ 
How many students said they prefer both Starry Night and Sunset Lodge?_______ 

Learn It 1

VIDEO: Types of Data: Categorical vs Numerical Data
In the INTRO, you looked at a survey that gathered categorical data about prom options. Watch the video to learn about the different types of data. Then, answer the questions

Annotate the diagram with a definition or example for each type of data: categorical, numerical, discrete, and continuous.

Think back to the survey from the INTRO. What two categories did the prom committee collect data on? These are called the categorical variables._______ &_______ 

VIDEO: Two-Way Tables
We can organize data on two categorical variables by using a two-way table. A two-way table uses rows to represent one categorical variable and columns to represent the second categorical variable. Each cell of the table tells us how many data points fall into that particular intersection and totals are often included at the end of each row and column. Watch the video walkthrough and answer the questions.
Complete the two-way table using the data from the Intro.
Some of the survey results are:
The survey included 92 different students.
20 students said they’d prefer Starry Night at the Aquarium.
43 students said they’d prefer Sunset Lodge over the Aquarium.
47 students said they’d prefer Under the Sea over Starry Night.
18 students said they’d prefer Under the Sea at Sunset Lodge.

Complete the two-way table using the data from the Intro.
Some of the survey results are:
The survey included 92 different students.
20 students said they’d prefer Starry Night at the Aquarium.
43 students said they’d prefer Sunset Lodge over the Aquarium.
47 students said they’d prefer Under the Sea over Starry Night.
18 students said they’d prefer Under the Sea at Sunset Lodge.

Practice It

High School Graduates: 6 Months Later
You’ve finally made it - you’ve graduated from high school! But what comes next? Let’s look at some data to see what recent high school graduates are doing
The table below shows observational data about the education and employment of recent high school graduates. It is based on the nationally representative sample from the Current Population Survey. Study the table and answer the questions.

What was the population for this table?_______ 
How many people were included in the sample studied?_______ 
What are the two categorical variables being studied in this table?_______ &_______ 
How many people surveyed are enrolled at a 4-year college?_______ 
If you wanted to know the total number of high school graduates who were in the labor force, which boxes would you add together? 
Note: the labor force includes both people who are employed and people who are unemployed and looking for work._______ &_______ 

Write one question that you could answer using the information in this table.

Explore It

Relative Frequency Table
The table below shows the same data about recent high school graduates. However, it is organized differently to show the percentage of people who gave each response, instead of the number.
This is called a relative frequency table. It is a type of two-way table that shows percentages rather than counts. It is helpful for seeing if there is an association between two variables.

The denominator used to calculate each percentage is 2732. What does that represent?_______ 
Out of all recent high school graduates, what percentage are enrolled in a 4-year college and employed?_______ 
Find the cell with the value 6%. What is that cell telling you?_______ 
What percentage of recent high school graduates are enrolled in a 4-year college?_______ 
If 3 million students graduate from high school in 2025 and these trends stay the same, how many graduates would you expect to attend 2-year college after graduation?_______ 

Represented Another Way
Mahlet wanted to find out if educational enrollment was associated with employment. Using the same data set about recent high school graduates, she built a different relative frequency table to compare the percentage of people who were employed, unemployed, or not in the labor force across each educational group.

How is Mahlet’s table different than the other tables we’ve seen for this data set?

Out of all recent high school graduates enrolled in a 4-year college, 73% are not in the labor force. Make an inference - why do you think that percentage is so high?

Out of recent high school graduates who are not enrolled in school, what percentage are employed?_______ 

Learn It 2

Associations Between Variables
You’ve learned about correlation in previous lessons; when we talk about two-way tables, we use the term association to mean something similar.
Association refers to a relationship between two variables: when one variable changes, so does the other one. Correlation is a type of association that tells us more about the shape and strength of the relationship.
We can use relative frequency tables to determine whether two variables have an association. One of the easiest ways to know if there is an association is to work backwards: check if the variables have NO association. If there’s no association, the relative frequency values should be very similar across each column or row.
Part 1: No Association
The table below is an example of two variables with no association; it shows the percentage of American children with health insurance by age. You can see that the percentage of children with health insurance stays approximately the same in each age group.

Hypothesize: why is there no association between age and having health insurance for children?

How might the table be different if there was an association - if children were less likely to have health insurance as they got older?

Part 2: Association
The table below shows the percentage of American adults with health insurance by education level. Study the table and answer the questions.

Find the cell in the table with the value 91%. What is this cell telling you?

Based on this observational data, Owen concludes that there is an association between education level and having health insurance. What evidence from the table supports that conclusion?

Application

Level 1

Part 1: Graduation Rates and College Type
Of students who enroll at 4-year colleges, how many graduate? Let’s explore some data about the graduation rates at different types of 4-year colleges: public, private non-profit, and private for-profit.
The table below based on a nationally representative sample of full-time students at 4-year colleges[1].

What does the cell with the value 1524 tell you?_______ 
How many people surveyed attended public colleges?_______ 

Complete the first row of the relative frequency table below to show the percentage of students at public colleges who graduated _______ and did not graduate._______ 

Part 2: Student Loan Associations

Which of the data sets shows no association between the two variables? Explain your reasoning.

Level 2
Part 1: Education and Employment
How does education level relate to unemployment rates? Explore the data below to find out.
The relative frequency table shows the percentage of adults who are employed by level of education. The data focuses on adults over 25 years old who are in the labor force (looking for work).

Find the cell with the value 3.5%. What is that cell telling you?

What percentage of adults with a high school diploma are employed?

Part 2: Comparing Occupations
Different jobs have different educational requirements. Some careers require a specific degree, while others have more flexible requirements. Let’s explore 5 careers where workers have similar levels of education.

	categorical	discrete	continuous
How tall are you?
What is your favorite color?
How many pets do you have?
Rate your experience on a scale of 1 to 10.

	categorical	discrete	continuous
How tall are you?
What is your favorite color?
How many pets do you have?
Rate your experience on a scale of 1 to 10.

5/30 FA 9.3 Two Way Tables

OBJECTIVES & STANDARDS

DISTRIBUTION & PLANNING

OBJECTIVES & STANDARDS

DISTRIBUTION & PLANNING

5/30 FA 9.3 Two Way Tables

OBJECTIVES & STANDARDS

DISTRIBUTION & PLANNING

OBJECTIVES & STANDARDS

DISTRIBUTION & PLANNING

ANALYZE: Prom Decisions

VIDEO: Types of Data: Categorical vs Numerical Data

Annotate the diagram with a definition or example for each type of data: categorical, numerical, discrete, and continuous.

VIDEO: Two-Way Tables

High School Graduates: 6 Months Later

Write one question that you could answer using the information in this table.

Relative Frequency Table

Represented Another Way

How is Mahlet’s table different than the other tables we’ve seen for this data set?

Out of all recent high school graduates enrolled in a 4-year college, 73% are not in the labor force. Make an inference - why do you think that percentage is so high?

Associations Between Variables

Hypothesize: why is there no association between age and having health insurance for children?

How might the table be different if there was an association - if children were less likely to have health insurance as they got older?

Find the cell in the table with the value 91%. What is this cell telling you?

Based on this observational data, Owen concludes that there is an association between education level and having health insurance. What evidence from the table supports that conclusion?

Level 1

Part 1: Graduation Rates and College Type

Which of the data sets shows no association between the two variables? Explain your reasoning.

Level 2

Part 1: Education and Employment

Find the cell with the value 3.5%. What is that cell telling you?

What percentage of adults with a high school diploma are employed?

Part 2: Comparing Occupations

Use the first two-way table to complete the relative frequency table below.

ANALYZE: Prom Decisions

VIDEO: Types of Data: Categorical vs Numerical Data

Annotate the diagram with a definition or example for each type of data: categorical, numerical, discrete, and continuous.

Read each survey question below and determine what type of data would be collected in response. For each question, circle categorical, discrete, or continuous.

VIDEO: Two-Way Tables

Which options do you think the prom committee should choose? Explain your reasoning.

High School Graduates: 6 Months Later

Write one question that you could answer using the information in this table.

Relative Frequency Table

Playing with Percentages

In the relative frequency table above, you saw another percentage describing the same group of 228 graduates: 8% of all recent graduates said they were both currently employed AND enrolled in 2-year college. Why are these three percentages different?

Represented Another Way

How is Mahlet’s table different than the other tables we’ve seen for this data set?

Out of all recent high school graduates enrolled in a 4-year college, 73% are not in the labor force. Make an inference - why do you think that percentage is so high?

Associations Between Variables

Hypothesize: why is there no association between age and having health insurance for children?

How might the table be different if there was an association - if children were less likely to have health insurance as they got older?

Find the cell in the table with the value 91%. What is this cell telling you?

Based on this observational data, Owen concludes that there is an association between education level and having health insurance. What evidence from the table supports that conclusion?

Imagine a law passed tomorrow that required everyone to complete at least an associate’s degree. Do you think that would that cause more Americans to have health insurance? Why or why not?

Make an inference: What is one other variable that you think could be related to either education and/or health insurance?

Level 1

Part 1: Graduation Rates and College Type

Is there an association between the type of college and graduation rate? Explain your reasoning.

Which of the data sets shows no association between the two variables? Explain your reasoning.

Level 2

Part 1: Education and Employment

Find the cell with the value 3.5%. What is that cell telling you?

What percentage of adults with a high school diploma are employed?

There are approximately 15,318,000 adults in the labor force with an associate’s degree. Based on this data, how many of those adults would you expect to be unemployed?

Is there an association between education and employment? Explain your reasoning.

Make an inference: why are unemployment rates similar for adults with doctoral degrees and professional degrees?

Part 2: Comparing Occupations

Use the first two-way table to complete the relative frequency table below.

Read each survey question below and determine what type of data would be collected in response. For each question, circle categorical, discrete, or continuous.

Which options do you think the prom committee should choose? Explain your reasoning.

Playing with Percentages

In the relative frequency table above, you saw another percentage describing the same group of 228 graduates: 8% of all recent graduates said they were both currently employed AND enrolled in 2-year college. Why are these three percentages different?

Imagine a law passed tomorrow that required everyone to complete at least an associate’s degree. Do you think that would that cause more Americans to have health insurance? Why or why not?

Make an inference: What is one other variable that you think could be related to either education and/or health insurance?

Is there an association between the type of college and graduation rate? Explain your reasoning.

There are approximately 15,318,000 adults in the labor force with an associate’s degree. Based on this data, how many of those adults would you expect to be unemployed?

Is there an association between education and employment? Explain your reasoning.

Make an inference: why are unemployment rates similar for adults with doctoral degrees and professional degrees?