Linear Data, Equations and Least Squares Regression

Author

Kevin E Kalinowski - University of North Texas - CECS 5420: Web Authoring - SS2 2003 - Assignment 1

Unit Overview

Students use a variety of techniques to collect data that is linear
in nature. Students interpret the slope, y-intercept and correlation coefficients
of the trend lines using least squares linear regression modeling. Students
use a spreadsheet program to store the data and generate scatter charts
based on the data. Students present their findings to their peers using
a presentation application, and publish their presentation to a web server
for peer review. Students analyze the effectiveness of various presentations
methods.

About the Plan

This Unit Plan consists of four connected lessons that spans five to
ten days, depending on the availability of technology resources and
skill level of the students. Its purpose is the connection of mathematical
concepts and integration of technology applications. Although lessons can
be used individually, it is recommended that this series of lessons be used
in its entirety and in the suggested sequence.

Prerequisite Skills and Knowledge

- Demonstrate basic Algebraic and Arithmetic skills and concepts
- State the definition of an equation, slope, and y-intercept
- Graph a linear equation on paper, using appropriate domain and range values, scales and labels
- Calculate the slope and y-intercept of a line

Materials and Equipment

- Hardware
- Computer Lab
- File Storage (floppy disks or networked file server)
- Internet Access
- LCD Projector connected to a computer in class
- Software
- Internet Browser
- Microsoft Excel
- Microsoft PowerPoint
- TI-83 Timer and Data Collection Programs
- Equipment
- Bathtub
- Meter stick
- TI-83 Graphing Calculator
- Printed

Lesson Overviews

- Lesson One: Cruisin'
- Introduces students to Microsoft Excel and how to use the application to produce charts and linear regression lines. Students analyze the slope, y-intercept and correlation coefficient of the lines.
- Lesson Two: Down The Drain
- Continues with linear regression line analysis, but with data producing a negative slope and a y-intercept other than at the origin.
- Lesson Three: Pick Some Data, Any Data
- Allows students to use the Internet to find their own real-life data to plot and analyze.
- Lesson Four: It's Showtime!
- Provides an opportunity for students to present their charts and analysis, defend their work, and view the presentations of their classmates.

References and Resources

- Exploring Data: Datasets http://exploringdata.cqu.edu.au/datasets.htm
- Exploring Data: Linear Regression http://exploringdata.cqu.edu.au/lin_reg.htm
- Exploring Data: Student Generated Linear Data http://exploringdata.cqu.edu.au/st_dat2l.htm
- Investigating Linear Relationships: The Regression Line and Correlation http://illuminations.nctm.org/imath/912/LinearRelationships/student/index.html
- Interpreting the "Real-Life" Meaning of Graphical Representations of Data http://illuminations.nctm.org/lessonplans/9-12/real_life/index.html
- Gary C. Ramseyer's First Internet Gallery of Statistical Jokes http://www.ilstu.edu/%7Egcramsey/Gallery.html
- Linear Regression http://www.mste.uiuc.edu/regression/titlepage.html
- Mrs. Garrett's Introduction to Linear Regression http://www.kenston.k12.oh.us/khs/math/mrsg_project.htm
- Regression Applet http://www.stat.sc.edu/%7Ewest/javahtml/Regression.html
- Solving Linear Regression Problems Using the TI 83 Graphing Calculator http://www.askeric.org/Virtual/Lessons/Mathematics/Statistics/STA0002.html