## Unit 8.19 Sample MAD Spreadsheet.xlsx - Section 4: Task

*Unit 8.19 Sample MAD Spreadsheet.xlsx*

# Comparing Mean Absolute Deviation

Lesson 19 of 22

## Objective: SWBAT: • Collect and display data in a table and line plot • Define mean absolute deviation. • Calculate the mean and mean absolute deviation of a data set. • Compare the distribution of two data sets using mean absolute deviation. • Use Microsoft Excel to analyze data.

## Big Idea: What does the mean absolute deviation tell us? Students use the data they collected in the previous lesson and Microsoft Excel to analyze data sets.

*50 minutes*

#### Do Now

*7 min*

See my **Do Now** in my Strategy folder that explains my beginning of class routines.

Often, I create do nows that have problems that connect to the task that students will be working on that day. Today I want students to analyze a line graph in order to answer questions. Each edition of Scholastic News typically includes a graph at the end each edition.

I ask for students to share their thinking. Students are engaging in **MP3: Construct viable arguments and critique the reasoning of others**.

*expand content*

I review the vocabulary with students. If students struggle to remember the definitions, I have them review their notes from the previous lesson. I want students to be able to explain that the MAD is the average distance from each value in a data set and the mean. I also want students to understand that the MAD is a measure of variability since it deals with the spread of values in a data set.

#### Resources

*expand content*

I explain that Data Set E and F came from two groups of people measuring how long each person thought it took for 30 seconds to pass. Students use the data in the tables to create two line plots. I have students work in partners to create line plots and calculate the mean absolute deviation.

As students work, I walk around and monitor student behavior and progress. If students struggle to complete a step, I tell them to look at their notes from the previous lesson.

Once students have completed the problems, we come back together to review their work. I ask for a student to show and explain how they calculated the MAD for Data set E. They ask their classmates for questions or comments about their work. Then I ask another student to show and explain how they calculated the MAD for Data Set F. They ask their classmates for questions or comments about their work. I ask students how they can use the line plots to support what they found out about the MAD for the data sets. I want students to use words like “clustered” and “spread out” to compare the data on the line plots.

#### Resources

*expand content*

#### Task

*15 min*

**Notes:**

- I
**Create Heterogeneous Groups**of 4 students. - Each student needs access to a laptop with Microsoft Excel.
- Before printing this packet, I input the data from each of my four classes into the packet. This way, each group member has the data they need to complete the task.

I explain the task. Students get their laptops and move into groups. Students are engaging in **MP5: Use appropriate tools strategically **and** MP6: Attend to precision**.

If I see a number of students struggling with the same step, I will model it on my own spreadsheet on the projector. If students successfully complete their task, they can work on the Challenge.

*expand content*

#### Closure and Ticket to Go

*13 min*

I have students share out the MAD for each class. I read the closure problems. Students work independently to answer them. Students share out their ideas. I want students to be able to answer question 3 and 4 and use the data set and the MAD to justify their choices. Students are engaging in **MP3: Construct viable arguments and critique the reasoning of others.**

I pass out the **Ticket to go **and the **Homework. **

*expand content*

##### Similar Lessons

Environment: Urban

###### Change and Central Tendency

*Favorites(12)*

*Resources(17)*

Environment: Urban

###### The Egg in a Flask Mystery (Day 1 of 2)

*Favorites(24)*

*Resources(18)*

Environment: Suburban

- UNIT 1: Intro to 6th Grade Math & Number Characteristics
- UNIT 2: The College Project - Working with Decimals
- UNIT 3: Integers and Rational Numbers
- UNIT 4: Fraction Operations
- UNIT 5: Proportional Reasoning: Ratios and Rates
- UNIT 6: Expressions, Equations, & Inequalities
- UNIT 7: Geometry
- UNIT 8: Geometry
- UNIT 9: Statistics
- UNIT 10: Review Unit

- LESSON 1: 100 Students Project: What If The World Were 100 People?
- LESSON 2: 100 Students Project: What do we want to know about our students?
- LESSON 3: 100 Students Project: Revising Questions & Planning the Survey
- LESSON 4: 100 Students Project: Conducting the Survey
- LESSON 5: 100 Students Project: Tallying Data and Brainstorming about Presentations
- LESSON 6: 100 Students Project: Analyzing Survey Results
- LESSON 7: 100 Students Project: Presenting Your Findings
- LESSON 8: 100 Students Project: Project Reflection
- LESSON 9: Median, Mode, and Range
- LESSON 10: Mean
- LESSON 11: Playing with Measures of Central Tendency
- LESSON 12: Choosing the Best Measure of Center
- LESSON 13: Show what you know
- LESSON 14: Introduction to Box Plots
- LESSON 15: Box Plots and Interquartile Range
- LESSON 16: Arm Span Day 1
- LESSON 17: Arm Span Day 2
- LESSON 18: Mean Absolute Deviation
- LESSON 19: Comparing Mean Absolute Deviation
- LESSON 20: Selecting Measures of Center and Variability
- LESSON 21: Statistics Jeopardy
- LESSON 22: Unit Test