Simple Interpolation of given XY pairsIf you have some XY data, and want to interpolate to find new Y values from an
array of new X values, it can be done easily.
Suppose you have
DATA1
A B
10 5
11 6
12 7
13 8
and you want
DATA2
A B
10 5
10.5 5.5
11 6
11.5 6.5
12 7
12.5 7.5
13 8
then simply construct a new X column in a new worksheet, so you now have
DATA2
A B
10
10.5
11
11.5
12
12.5
13
and type DATA2_B=DATA1_B(DATA2_A) and hit ENTER
Origin will assign new values to DATA2_B using DATA1_A's values as new X values
for Data1_B.