You are not logged in.
login | register
Tool: The Best-Fit Straight Line: How do you determine it?
Screenshot:
Tool Thumbnail

Go to: http://academic.pgcc.edu/~ssinex/regression.xls (opens a new window)
Description: Linear regression is a powerful technique for fitting data as students begin mathematical modeling. This is a quick introduction to the technique using an interactive spreadsheet that gives students a basis of understanding to use linear regression. An "eyeball" fit is done to minimize the sum of the squared deviations. The "eyeball" line is then compared to a regression line. Instructions for use are provided on the spreadsheets using comment boxes. The Guide link is a "How to" for developing interactive Excel spreadsheets or "Excelets."
Technology Type: Excel 
Guide: User's Guide (opens a new window)
Author: Scott A. Sinex
Language: English 
Cost: Does not require payment for use

Average Rating:  [2] Login to rate this resource
My MathTools: Login to Subscribe / Save This
Reviews: be the first to review this resource
Discussions: start a discussion of this resource

Courses: Algebra Analyzing Linear Data, Line of Best Fit

  Bogart
Comment:Great site for developing an Internet Workshop for students taking statistics and learning about lines of best fit and deviations...Thanks