What is the simplest way to interpolate and lookup in an x,y table in excel?

Posted by dassouki on Super User See other posts from Super User or by dassouki
Published on 2013-07-28T12:07:59Z Indexed on 2013/11/08 4:01 UTC
Read the original article Hit count: 282

Filed under:

microsoft-excel-2010

|

mathematica

I would like to do a lookup and interpolation based on x, y data for the following table. I'd like the equation to be as simple as possible to reduce the amount of possible errors. The full table is about 50 rows x 30 columns. I have about 20 of those tables. Here is an extract from one:

   A       B      C    D 
1        0.1    0.2   0.3 
2  2.4   450    300   50
3  2.3   500    375   52
4  2.1   550    475   55
5  1.8   600    600   60

For example, the equation should find the value for x = 2.27 and y = 0.15

© Super User or respective owner

Related posts about microsoft-excel-2010

SQLAuthority News – Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010

as seen on SQL Authority - Search for 'SQL Authority'
Microsoft has really and truly created some buzz for PowerPivot. I have been asked to show the demo of Powerpivot in recent time even when I am doing relational database training. Attached is the few details where everyone can download PowerPivot and use the same. Microsoft SQL Server 2008 R2 –… >>> More
Microsoft Excel 2010

as seen on Super User - Search for 'Super User'
I've one "master" sheet in the Excel 2010 file with all my outstanding orders detail and also reflecting how many days the orders have been outstanding. I've 4 other sheets, I'd like to extract the orders from the "master" sheet to to each of these sheets grouping them into these criteria. The 4… >>> More
how to sum the amount of cells with the same number in a column - Microsoft Excel 2010

as seen on Super User - Search for 'Super User'
My english isn't that good, I hope you understand what I wan't to accomplish I have a column (A) with different zip codes ( total of 3583 rows). I need a formula/function to go through each cell and the come up with sum of how many instances (column B) there are of the same zip code (column C).There… >>> More
Microsoft Excel 2010 How to reference a table to another sheet

as seen on Super User - Search for 'Super User'
I am using Excel 2010. I got a sheet name "March" I would like to duplicate it (with reference / link) to another sheet called "Summary" which included January, Feb, and March. In the summary tab I would add another column called "Month" and will duplicate the value "March" or their tab month… >>> More
Offset the tickmarks of a secondary axis

as seen on Super User - Search for 'Super User'
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA. Here is an example of what I mean (I removed… >>> More

Related posts about mathematica

Debugging a working program on Mathematica 5 with Mathematica 7

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everybody, I'm currently reading the Mathematica Guidebooks for Programming and I was trying to work out one of the very first program of the book. Basically, when I run the following program: Plot3D[{Re[Exp[1/(x + I y)]]}, {x, -0.02, 0.022}, {y, -0.04, 0.042}, PlotRange -> {-1, 8}, PlotPoints… >>> More
Mathematica 8 crashes Ubuntu 13.10

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have Mathematica 8 installed on my Ubuntu laptop since 2011. I updated Ubuntu several times, and experienced no problems with Mathematica. It also worked smoothly after I updated Ubuntu to 13.10 (it worked for sure for a week after update). When I tried to start Mathematica today by executing… >>> More
What is in your Mathematica tool bag?

as seen on Stack Overflow - Search for 'Stack Overflow'
We all know that Mathematica is great, but it also often lacks critical functionality. What kind of external packages / tools / resources do you use with Mathematica? I'll edit (and invite anyone else to do so too) this main post to include resources which are focused on general applicability in… >>> More
Running Mathematica-5 remotely

as seen on Server Fault - Search for 'Server Fault'
I have Mathematica 5 - a powerful CAS. I have a cheap netbook (running Windows XP), wich not only is too slow to run mathmatica on, I doubt it has the harddrive space. I do however have remote access to a number of very powerful computers, (most of wich run variose Linuxes, but one of which is Windows… >>> More
How to extract a Date from an SQLDateTime object in Mathematica

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to do a plot of a time series with DateListPlot. I want to feed it a time series I obtain from an SQL database. When I retrieve the time series the list is composed of SQLDateTime entries that DateListPlot doesn't understand. In[24]:= t=SQLExecute[conn, "select timestamp,value from… >>> More