Please add an INTERPOLATE function. For vector or array data.

You have SLOPE, INTERCEPT and LINEST, making an interpolation is rather easy
from there.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dan Gauthier" <Dan [email protected]> wrote in message
news:[email protected]...
> Please add this function which may be used either for a vector set of data
> or
> for a 2 dimensional array of data.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions

Which you can do with LINEST etc. or more directly with TREND or
FORECAST by including just the relevant surrounding points (instead of
the entire data set) for a given interpolation.

Jerry

MrShorty wrote:

> I would agree with the OP on this one. LINEST etc. are curve fitting
> functions, not interpolating functions. Sometimes when you have a
> table of data, it is easier/preferable to approximate the function as a
> series of straight lines connecting the data points (similar to what a
> line chart/XY chart does) rather than attempt to fit the data to a
> curve.

You have SLOPE, INTERCEPT and LINEST, making an interpolation is rather easy
from there.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dan Gauthier" <Dan [email protected]> wrote in message
news:[email protected]...
> Please add this function which may be used either for a vector set of data
> or
> for a 2 dimensional array of data.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions

Bernard Liengme wrote...
>You have SLOPE, INTERCEPT and LINEST, making an interpolation is rather easy
>from there.
....

LINEST would be gross overkill. Besides, FORECAST and TREND would be
far easier than any of these. The problem is that using it to
interpolate in a table (TBL) for a value (v) involves expressions like

TREND(OFFSET(TBL,MATCH(v,INDEX(TBL,0,XvalCol)),YvalCol-1,2,1),
OFFSET(TBL,MATCH(v,INDEX(TBL,0,XvalCol)),XvalCol-1,2,1),v)

You may like these, but they are a bit long. When they're general like
this, they eat 3 levels of nested function calls. A simpler approach
would be handy, but I suspect we won't see it in Excel until a few
months after Hell organizes an Ice Hockey league.

Which you can do with LINEST etc. or more directly with TREND or
FORECAST by including just the relevant surrounding points (instead of
the entire data set) for a given interpolation.

Jerry

MrShorty wrote:

> I would agree with the OP on this one. LINEST etc. are curve fitting
> functions, not interpolating functions. Sometimes when you have a
> table of data, it is easier/preferable to approximate the function as a
> series of straight lines connecting the data points (similar to what a
> line chart/XY chart does) rather than attempt to fit the data to a
> curve.

You have SLOPE, INTERCEPT and LINEST, making an interpolation is rather easy
from there.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dan Gauthier" <Dan [email protected]> wrote in message
news:[email protected]...
> Please add this function which may be used either for a vector set of data
> or
> for a 2 dimensional array of data.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions

Bernard Liengme wrote...
>You have SLOPE, INTERCEPT and LINEST, making an interpolation is rather easy
>from there.
....

LINEST would be gross overkill. Besides, FORECAST and TREND would be
far easier than any of these. The problem is that using it to
interpolate in a table (TBL) for a value (v) involves expressions like

TREND(OFFSET(TBL,MATCH(v,INDEX(TBL,0,XvalCol)),YvalCol-1,2,1),
OFFSET(TBL,MATCH(v,INDEX(TBL,0,XvalCol)),XvalCol-1,2,1),v)

You may like these, but they are a bit long. When they're general like
this, they eat 3 levels of nested function calls. A simpler approach
would be handy, but I suspect we won't see it in Excel until a few
months after Hell organizes an Ice Hockey league.

Which you can do with LINEST etc. or more directly with TREND or
FORECAST by including just the relevant surrounding points (instead of
the entire data set) for a given interpolation.

Jerry

MrShorty wrote:

> I would agree with the OP on this one. LINEST etc. are curve fitting
> functions, not interpolating functions. Sometimes when you have a
> table of data, it is easier/preferable to approximate the function as a
> series of straight lines connecting the data points (similar to what a
> line chart/XY chart does) rather than attempt to fit the data to a
> curve.

You have SLOPE, INTERCEPT and LINEST, making an interpolation is rather easy
from there.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dan Gauthier" <Dan [email protected]> wrote in message
news:[email protected]...
> Please add this function which may be used either for a vector set of data
> or
> for a 2 dimensional array of data.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions

Bernard Liengme wrote...
>You have SLOPE, INTERCEPT and LINEST, making an interpolation is rather easy
>from there.
....

LINEST would be gross overkill. Besides, FORECAST and TREND would be
far easier than any of these. The problem is that using it to
interpolate in a table (TBL) for a value (v) involves expressions like

TREND(OFFSET(TBL,MATCH(v,INDEX(TBL,0,XvalCol)),YvalCol-1,2,1),
OFFSET(TBL,MATCH(v,INDEX(TBL,0,XvalCol)),XvalCol-1,2,1),v)

You may like these, but they are a bit long. When they're general like
this, they eat 3 levels of nested function calls. A simpler approach
would be handy, but I suspect we won't see it in Excel until a few
months after Hell organizes an Ice Hockey league.

Which you can do with LINEST etc. or more directly with TREND or
FORECAST by including just the relevant surrounding points (instead of
the entire data set) for a given interpolation.

Jerry

MrShorty wrote:

> I would agree with the OP on this one. LINEST etc. are curve fitting
> functions, not interpolating functions. Sometimes when you have a
> table of data, it is easier/preferable to approximate the function as a
> series of straight lines connecting the data points (similar to what a
> line chart/XY chart does) rather than attempt to fit the data to a
> curve.

Please add this function which may be used either for a vector set of data or
for a 2 dimensional array of data.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

You have SLOPE, INTERCEPT and LINEST, making an interpolation is rather easy
from there.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dan Gauthier" <Dan [email protected]> wrote in message
news:[email protected]...
> Please add this function which may be used either for a vector set of data
> or
> for a 2 dimensional array of data.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions

Bernard Liengme wrote...
>You have SLOPE, INTERCEPT and LINEST, making an interpolation is rather easy
>from there.
....

LINEST would be gross overkill. Besides, FORECAST and TREND would be
far easier than any of these. The problem is that using it to
interpolate in a table (TBL) for a value (v) involves expressions like

TREND(OFFSET(TBL,MATCH(v,INDEX(TBL,0,XvalCol)),YvalCol-1,2,1),
OFFSET(TBL,MATCH(v,INDEX(TBL,0,XvalCol)),XvalCol-1,2,1),v)

You may like these, but they are a bit long. When they're general like
this, they eat 3 levels of nested function calls. A simpler approach
would be handy, but I suspect we won't see it in Excel until a few
months after Hell organizes an Ice Hockey league.

Which you can do with LINEST etc. or more directly with TREND or
FORECAST by including just the relevant surrounding points (instead of
the entire data set) for a given interpolation.

Jerry

MrShorty wrote:

> I would agree with the OP on this one. LINEST etc. are curve fitting
> functions, not interpolating functions. Sometimes when you have a
> table of data, it is easier/preferable to approximate the function as a
> series of straight lines connecting the data points (similar to what a
> line chart/XY chart does) rather than attempt to fit the data to a
> curve.