16.11 Simple Column/Curve Math


Description

There are two user-interface tools for performing simple math operations on data: mathtool and vmathtool.

User interface tool Access by Arithmetic operations
mathtool Analysis: Mathematics: Simple Curve Math... (with Worksheet/Graph active) For a curve or XY data range
vmathtool Analysis: Mathematics: Simple Column Math... (with Worksheet active) For a single column

Both tools perform arithmetic operations on data in worksheet columns or plotted curves, but the input and operand for the both tools are different.

For vmathtool, the input data is a single column and the operand is a single column or constant, the mathematical operation is performed between the input column and the operand column or constant.

For mathtool, the input data is a XY range (or curve) and the operand is also a XY range (or curve) or constant, the mathematical operation is performed between the input Y column and the reference Y column or constant; There are three cases for X range:

  • If X range for input and reference X is identical,operations perform on the corresponding Y range for input and reference directly.
  • If X range for input and reference is different , operations perform on the corresponding Y range for input and reference after the XY range interpolation or extrapolation. In addition:
  • If the option Use Common Range Only has been checked, the X values in Result is consist of all X values in sharing range, while the corresponding Y values are calculated after interpolation (extrapolation).
Use common range.png
  • If the option Use Common Range Only hasn't been checked, the X values in Result is the same as X input, while the corresponding Y values calculated after interpolation (extrapolation) as well.
Not use common range.png

For detailed information including programming-related information, consult the X-Function Reference: vmathtool and the mathtool

Dialog Options

Recalculate

Controls recalculation of analysis results.

  • None
  • Auto
  • Manual

For more information, see: Recalculating Analysis Results

Input

Input XY data range or curve.

For help with range controls, see: Specifying Your Input Data

Operator

Specify an operator: Add, Subtract, Divide, Multiply, or Power.

Operand


  • Const
    Use constant as operand.
  • Reference Data
    Use reference curve or column as operand.
Reference Data

Specify a curve (XY Range) or column as operand. This option is available when Operand = Reference Data. When two curves' ranges do not coincide, the two curves will be interpolated or extrapolated by linear interpolation, before the specified operation is performed.

Const

Specify a constant as operand. This option is available when Operand = Const.

Use Common Range Only (mathtool only)

Operate on the common range between the two curves (or XY ranges). This check box is available when Operand = Reference Data.

Rescale Source Graph (mathtool only)

Rescale the source graph, as needed, after computations have completed.

Output

Specify the output data range.

For help with the range controls, see: Output Results.