Analysis: Mathematics: Subtract Reference Data
Subtract one dataset from another
subtract_ref iy1:=[Book1]Sheet1!(1,2) iy2:=[Book1]Sheet1!(3,4) oy:=[Book1]Sheet1!(5,6) // Subtracts XY pair in cols 3&4 from XY pair in 1&2 and puts subtracted XY pair in cols 5&6.
Please refer to the page for additional option switches when accessing the x-function from script
Input
XYRange
Input XY data range or curve.
Specify the reference data to be subtracted.
int
Operate only where data ranges overlap.
Specify whether to rescale the source graph after subtraction.
Output
The output data range. See the syntax here.
double
Minimum X value of output curve.
Maximum X value of output curve.
Mean X value of output curve.
Minimum Y value of output curve.
Maximum Y value of output curve.
Mean Y value of output curve.
This tool is used to subtract one curve from another. When the two datasets' coordinates differ, the two curves will be interpolated or extrapolated with linear interpolation before subtraction occurs.
Then you can see a new curve is created.
Keywords:baseline correction, subtraction