# Interpolating z(x,y) data point from 4 data points (rectangular)?

• Jun 20th 2011, 06:57 AM
ShouldKnowBetter
Interpolating z(x,y) data point from 4 data points (rectangular)?
Hello

I am trying to determine the general formula that will allow me to interpolate a value "z" related to any point (x,y) where x1<x<x2 and y1<y<y2 from a surface map defined by 4 points z1(x1,y1),z2(x1,y2),z3(x2,y1) and z4(x2,y2).

I can do it in Excel for discrete values, and have tried using a kind of "weighted average" approach but I can't seem to nail this general formula.

Any help appreciated.

Refer to this Excel file for reference.

Thanks

SKB
• Jun 20th 2011, 08:27 AM
CaptainBlack
Re: Interpolating z(x,y) data point from 4 data points (rectangular)?
Quote:

Originally Posted by ShouldKnowBetter
Hello

I am trying to determine the general formula that will allow me to interpolate a value "z" related to any point (x,y) where x1<x<x2 and y1<y<y2 from a surface map defined by 4 points z1(x1,y1),z2(x1,y2),z3(x2,y1) and z4(x2,y2).

I can do it in Excel for discrete values, and have tried using a kind of "weighted average" approach but I can't seem to nail this general formula.

Any help appreciated.

Refer to this Excel file for reference.

Thanks

SKB

You will find this in Abramowitz and Stegun which is available on-line.

CB
• Jun 20th 2011, 06:04 PM
ShouldKnowBetter
Re: Interpolating z(x,y) data point from 4 data points (rectangular)?
Quote:

Originally Posted by CaptainBlack
You will find this in Abramowitz and Stegen which is available on-line.

CB

Thanks found it.