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
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

View 49,684 other resources for 8th - 10th Grade Math

© 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