Record arithmetic

Record Arithmetic window. Enter one mathematical expression per row to generate new records from existing records.

Record arithmetic (Data › Record Arithmetic) provides the option to perform arithmetic operations pointwise across records e.g. add two records together, sample-by-sample.

Record Arithmetic can be performed by a flexible interface that takes text input. Records are referred to with the r prefix, and permitted mathematical operations are the addition (+), subtraction (-), multiplication (*) and division (/), and brackets. For example, to add the first and second record: r1+r2. To calculate the average of the 2^nd, 3^rd and 4^th records: (r2+r3+r4)/3.

Multiple record arithmetic expressions over sets of records can be performed by inputting an expression on each row of the input table. The example below will result in a 2-record file, with the first record being the sum of the first and second record, and the second record being the sum of the second and third record.

In this example, the resulting dataset contains two records formed by adding records 1 and 2, and records 2 and 3, respectively.