You are not logged in.
login | register
Tool: Interpolation and Extrapolation: What is the Difference?
Screenshot:
Tool Thumbnail

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:  [1] 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