interpolation between datas

[keremgeliz]

Hello all. I have a table and i am using this table for read data.

My table like this:

a          b          c          e

0         10        5          20

100     200    -5         20

....

All datas are linear. I get (a) values for reference

how can i find b-c-d values when a=13?

Thank you

[GerdW · Accepted solution]

Hi kerem,

use the Interpolate1DArray function…

Example:

[Norbert_B]

If it is linear, you have to calculate the parameters for your linear equation. In case you don't know that equation (i hope you do, otherwise, pls learn the basic stuff before asking in some forums!): y = m*x + t

In your example, column a is x. The other columns represent the corresponding y.

So in case for column b:

10 = m*0 + t

200 = m*100 + t

Now solve both equations in order to get m and t for column b. Next step is to use m and t to compute your y for x = 13.

Easy enough.....

Norbert

[crossrulz]

Use Threshold 1D Array on your A column.  That will give you a fractional index that you can use with Interpolate 1D Array on your other columns.