Home |
Search |
Today's Posts |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
interpolation routine for Excel
The problem with forecast is that it does a linear regression of the line
through the points so that the line may not actually cross any of the points. What many of us would like is a function that draws a straight line between each individual point and extrapolates the value based on each line segment. "Gary''s Student" wrote: The FORECAST() function does a great job of linear interpolation as well as forecasting. -- Gary''s Student - gsnu200806 "Steve" wrote: Has anyone written an interpolation function for Excel? I have an equation that works, but it is a pain to edit and check each time. There should be a way to standardize it for use with most tables. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to do a Linear interpolation in excel? | Excel Worksheet Functions | |||
Converting a Access routine into an Excel macro? | Excel Discussion (Misc queries) | |||
how can I use excel to automatically generate routine report? | Excel Worksheet Functions | |||
help with interpolation and limit of interpolation | Excel Discussion (Misc queries) | |||
interpolation in excel | Excel Worksheet Functions |