Interpolation of x,y data

T

tasowers

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I need to interpolate a set of x,y data pairs with a different set of x. In Matlab this is called a one dimensional data interpolation. In this case I'm looking for a linear interpolation.

Thanks
 
M

Mike Middleton

tasowers -

There are many ways to interpolate in Excel. One simple way is to use the
FORECAST worksheet function,

FORECAST(x,known_y's,known_x's)

where the known y and x values could be just two data pairs.

- Mike
www.MikeMiddleton.com
 
Top