Hi all,
I have an x, y, and z column. X and Y have thousands of points, while Z has a first and last. I want to fill in the rest of Z somehow (interpolation was my best guess). I'm filling in gaps in bathymetry data with "best guess" points. So far I have linearly interpolated z values using x and y separately, then averaging those two columns. There has to be a more accurate method.
Any advice or code would be helpful.
Thanks!
Can you upload example workbook? Make sure to remove private informations.
Never use Merged Cells in Excel
The bold is given.
On a first looks it's seems fine..
What is your expected result?
I don't think I'm getting a wrong answer. I was just wondering if there is a way to interpolate in 3 dimensions, rather than doing 2 linear interpolations and averaging them. I thought there may be a method that proved more accurate.
You can't because you missing one variable.
For example if you have 3D like this gtgsissa.gif looking from "above" they look like all points are on same plane. You can not restore 3D from that plane. Therefore your average is as good as any other aproximation.
So the two given Z values (-54.3 and -50.75) are not enough to fill in the missing ones?
If you have two points how can you know are other points in between: linear, sine, cube, spiral or something else?
With 3rd point you could exlcude some (but not all)... More points you have more accurate interpolation you have.
With just 2 linear interpolation is as good as any other.
Ok, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks