|
Tool:
The Best-Fit Straight Line: How do you determine it? |
Screenshot:
|
| 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 |
|