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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Second x axis on x-y charts 0
Switching axis of a chart 4
Line charts with missing data 2
Excel opens a long list (13+) of worksheetsthat are saved on one of my iMacs 1
Date input format 0
Excel Charts 1
Microsoft Excel 2008 for Mac 3
Merging data from 2 workbooks 1

Top