INTERPOLATION(abscissae,ordinates,targets,interpolation)
abscissae: ordered abscissae of the given data points
ordinates: ordinates of the given data points
targets: abscissae of the interpolated data
interpolation: method of interpolation, defaults to 0 ('linear')
The output consists always of one column of numbers.
Possible interpolation methods are:
0: linear;
1: linear with averaging;
2: staircase;
3: staircase with averaging;
4: natural cubic spline;
5: natural cubic spline with averaging.
The abscissae must be given in increasing order. If any of interpolation methods 1 ('linear with averaging'), 3 ('staircase with averaging'), and 5 ('natural cubic spline with averaging') is used, the number of returned values is one less than the number of targets and the targets values must be given in increasing order. Strings and empty cells in abscissae and ordinates are ignored. If several target data are provided they must be in the same column in consecutive cells.