Analysis: Mathematics: Simple Column Math
Perform simple arithmetic on a single column.
Please refer to the page for additional option switches when accessing the x-function from script
Specifies input data range. The input data range can be a single column or a part of a column.
Specifies the Operator.
Specifies the operand type.
Specifies a data range (a single column or a part of a column) as operand. This option is available when Reference Data is selected from Operand drop-down list.
Specifies a constant as operand. This option is available when Constant is selected from Operand drop-down list.
Specifies the formula to calculate, in which x1 means Input1 and x2 means Reference data. This option is available when Custom is selected from Operator drop-down list.
Specifies the output data range
Minimum X value of output data range
Maximum X value of output data range
Mean X value of output data range
This tool performs simple arithmetic on a (part of) single column, or between two columns. You can add a constant on a set of data, or subtract a set of data by another one.
The following steps show you how to subtract a column by another.
A new column is added to the original worksheet. It shows the difference between "No Inhibitor" condition and "Competitive Inhibition" condition. The result worksheet should be as follow: