Introduction to Scatter Plots and Correlation

To have the students find positive, negative, and no correlation in different sets of data using MS Excel and present their findings.

The students will compare various baseball statistics to find the ones that correlate with winning.

The students are just beginning a new chapter, and this lesson serves to introduce the subject of scatter plots.

Introduce topic of study using power point presentation.Hand out Excel help handout. Help the class with any questions as they work in groups of 2 to accomplish their task. Have the students present in the front of the class with their findings. Assign homework.

Computers equipped with MS Excel Internet Access

AZ- Arizona Academics Standards

• Subject : Mathematics

• Subject/ Grade/ Domain : High School

• Strand Strand 2: Data Analysis, Probability, and Discrete MathematicsEvery student should understand and use all concepts and skills from the previous grade levels. The standards are designed so that new learning builds on preceding skills and are needed to learn new skills. Communication, Problem-solving, Reasoning & Proof, Connections, and Representation are the process standards that are embedded throughout the teaching and learning of mathematical strands.

• Concept Concept 1: Data Analysis (Statistics)Understand and apply data collection, organization and representation to analyze and sort data. Performance Objective

PO 2: Organize collected data into an appropriate graphical representation. Performance Objective

PO 6: Identify which of the measures of central tendency is most appropriate in a given situation. Performance Objective

PO 7: Make reasonable predictions based upon linear patterns in data sets or scatter plots. Performance Objective

PO 9: Draw inferences from charts, tables, graphs, plots, or data sets. Performance Objective

PO 13: Draw a line of best fit for a scatter plot. Performance Objective

PO 14: Determine whether displayed data has positive, negative, or no correlation.

• Subject : Technology

• Standard 3: Technology, Productivity,Tools.Students use technology tools to enhance learning, to increase productivity and creativity, and to collaboratively construct technology-enhanced models, prepare publications, and produce other creative works. • Grade Range : PROFICIENCY (Grades 9 through 12)

 • Key Idea/Concept 3T-P2: Use a variety of technology tools for data collection and analysis to support a decision See: Mathematics (3M-P3), Social Studies (1SS-P1,PO2) and Arts {Theatre} (1AT-P6) Performance Objective

PO 2: Create and use a spreadsheet to analyze variables (e.g., 12-month budget, loan rates, science and math experiments, and investment portfolios)

Home work section 1-1, pages 10 – 13, #5 – 13, 24, 26, 30, and 31