Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
" wrote:
Note, that interpolating by equation fitting will not neccesarily match the data points in the table - there will be some error. The only time the polynomial will exactly match the data is if the polynomial order is equal to the number of data points minus one. Increasing the order of the polynomial can lead to some very wild lines though. That is why (when interpolating) you only pass TREND or FORECAST the points necessary for the interpolation, not the entire data set. Jerry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Interpolating an x, y point from known x's and y's | Excel Worksheet Functions | |||
Interpolating an x, y point from known x's and y's | Excel Discussion (Misc queries) | |||
Interpolating an x, y point from known x's and y's | Excel Worksheet Functions | |||
Interpolating an x, y point from known x's and y's | Charts and Charting in Excel | |||
Interpolating an x, y point from known x's and y's | Excel Programming |