| Tool: Interpolation and Extrapolation: What is the Difference? |
Screenshot: 
|
||
| Go to: | http://academic.pgcc.edu/~ssinex/interpol_extrapol.xls (opens a new window) | ||
| Description: | Interpolation and extrapolation are two concepts in mathematical modeling that are very important for making predictions, an important science process, especially as students begin exploring linear models. An introduction can be done using an interactive spreadsheet. The “interpolate or extrapolate” worksheet allows students to discover the difference between the two terms graphically with only an understanding of the equation of a line. The “aluminum can data” worksheet, which assumes students are familiar with linear regression, then explores the dangers of extrapolation as the linear model appears to breakdown. The instructions for usage are all included on each worksheet plus additional information given via comment cells. 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: |
 [0]
|
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 | Is It Linear?, Line of Best Fit | |
|
| |||