Lesson Planet
Search educational resources
  • Sign In Try It Free
  • AI Teacher Tools
    • Discover Resources Search reviewed educational resources by keyword, subject, grade, type, and more
    • Curriculum Manager (My Content) Manage saved and uploaded resources and folders To Access the Curriculum Manager Sign In or Join Now
    • Browse Resource Directory Browse educational resources by subject and topic
    • Curriculum Calendar Explore curriculum resources by date
    • Lesson Planning Articles Timely and inspiring teaching ideas that you can apply in your classroom
    • Our Story
    • Frequently Asked Questions
    • Testimonials
    • Contact Us
  • Pricing
  • School Access
    • Your school or district can sign up for Lesson Planet — with no cost to teachers
      Learn More
  • Sign In
  • Try It Free

Hi, what do you want to do?

Create a lesson plan
Create a lesson plan
Generate resources with 80+ AI teacher tools
Generate resources with 80+ AI teacher tools
Search 200,000 instructional videos
Search 200,000 instructional videos
Find a teaching resource
Find a teaching resource
Correlation and Line of Best Fit Lesson PlanCorrelation and Line of Best Fit Lesson Plan
Publisher
West Contra Costa Unified School District
Resource Details
Curator Rating
Educator Rating
Not yet Rated
Grade
8th - 10th
Subjects
Math
1 more...
Resource Types
Lesson Plans
4 more...
Audience
For Teacher Use
Duration
2 hrs
Instructional Strategy
Direct Instruction
Technology
Database & Spreadsheet
Lesson Plan

Correlation and Line of Best Fit

Curated and Reviewed by Lesson Planet
This Correlation and Line of Best Fit lesson plan also includes:
  • Worksheet
  • Answer Key
  • Join to access all included materials

Computers are useful for more than just surfing the Internet. Pupils first investigate scatter plots and estimate correlation coefficients. Next, they use Microsoft Excel to create scatter plots and determine correlation coefficients and equations for best-fit lines.

45 Views 40 Downloads
CCSS: Designed

Concepts

correlation, correlation coefficient, line of best fit, trend lines, scatter plots

Additional Tags

math

Instructional Ideas

  • Team up with a computer instructor to teach the lesson

Classroom Considerations

  • Second half of lesson requires Microsoft Excel
  • Learners need to be able to write linear functions

Pros

  • Incorporates technology in the math classroom
  • Includes answer key

Cons

  • Instructions for Microsoft Excel may be outdated based on the version available in your classroom

Common Core

8.SP.A.2 HSS-ID.B.6.a HSS-ID.B.6.c

See similar resources:

Activity

Applying Correlation Coefficients - Educational Attainment and Unemployment

US Department of Commerce
Correlate education with unemployment rates. Individuals compare state and regional unemployment rates with education levels by calculating the correlation coefficient and analyzing scatter plots. Pupils begin by looking at regional data...
9th - 12th Math
CCSS: Designed
Lesson Plan

Correlation Coefficient

Project Maths
Of course, there might be a correlation! Young mathematicians investigate several different data sets, create scatter plots, and determine any correlation. They consider whether a causation exists between any of the variables in question.
9th - 12th Math
CCSS: Adaptable
Lesson Plan

Interpreting Correlation

EngageNY
Is 0.56 stronger than -0.78? Interpret the correlation coefficient as the strength and direction of a linear relationship between two variables. An algebra instructional activity introduces the correlation coefficient by estimating...
9th - 10th Math
CCSS: Designed
Performance

Connecting Scatter Plots and Correlation Coefficients Activity

Radford University
Collect a variety of bivariate data. Groups determine sets of data that would provide a positive, negative, and no correlation. Team members gather their data through out the week. Scholars plot the data and determine the relationship...
9th - 12th Math
CCSS: Adaptable
Assessment

Pre-Test Unit 9: Scatter Plots

Charleston School District
What do your classes know about statistics? Use a pre-test to determine their background.  Topics include scatter plots and lines of best fit, two-way frequency tables, and modeling with linear equations.
8th Math
CCSS: Designed
Instructional Video

Scatter Plots

National Education Association
What's my line, anyway? A video covers the aspects of finding an equation of the best-fit line for a set of data. It works through plotting the points to drawing a line that appears to represent the data. The presenter suggests finding...
9th - 12th Math
CCSS: Designed
Lesson Plan

Data Analysis and Probability: Graphing Candy with Excel

Curated OER
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...
5th - 8th Math
Instructional Video

How Do You Use a Scatter Plot to Find No Correlation?

Curated OER
How do you determine the correlation in a set of data? Plot the data, find the line of fit, then use that line to determine if the correlation is positive, negative, or no correlation. This tutorial demonstrates that when a line of fit...
2 mins 6th - 11th Math
Instructional Video

How Do You Use a Scatter Plot to Find a Positive Correlation?

Curated OER
You can use a scatter plot to determine if there is a positive, negative, or no correlation between the given data. After graphing data you need to find a line of fit, a line that best represents the data you've graphed. It will be the...
2 mins 6th - 11th Math
Lesson Plan

Let's Get Linear

Curated OER
Math whizzes utilize spreadsheets to examine linear modeling. They roll marbles down a ramp from three different heights and measure how far they roll. They use Excel to record their data and create a plot of their data.
8th - 10th Math
Try It Free
© 1999-2026 Learning Explorer, Inc.
Teacher Lesson Plans, Worksheets and Resources

Sign up for the Lesson Planet Monthly Newsletter

Open Educational Resources (OER)

  • Health
  • Language Arts
  • Languages
  • Math
  • Physical Education
  • Science
  • Social Studies
  • Special Education
  • Visual and Performing Arts
View All Lesson Plans

Discover Resources

  • Our Review Process
  • How it Works
  • How to Search
  • Create a Collection

Manage Curriculum

  • Edit a Collection
  • Assign to Students
  • Manage My Content
Contact Us Site Map Privacy Policy Terms of Use