4.6.3 Reduce Columns

Origin has a tool for reducing data by deleting or merging worksheet columns. Works on all or partial columns of the worksheet and reduces worksheet columns by deleting or statistically merging.


To open this dialog box:

  1. Activate the workbook.
  2. Click Worksheet: Reduce Columns... and open the wreducecols dialog box, which utilizes the wreducecols x-function.

Dialog Options

Recalculate

Controls recalculation of results

  • None
  • Auto
  • Manual

For more information, see: Recalculating Analysis Results

Input Worksheet

The data input range.

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

Reduce Method
  • Delete N columns, then skip M columns
Delete N columns, then skip M columns
  • Reduce N columns with merged values
Merge every N data points into one data point equal to the Merge by value.
Merge/Delete Columns

Option depends on your selection of Reduce Method: Delete N columns... (Delete Columns) or Reduce N columns... (Merge Columns). Number of columns to merge or delete.

Merge by

Available when Reduce Method = Reduce N columns.... Specify value to replace merged data points.

  • First Point
Replace every N data points with the value of the first merged point.
  • Last Point
Replace every N data points with the value of the last merged point.
  • Average
Replace every N data points with the average of the merged points.
  • Min
Replace every N data points with the minimum value of the merged points.
  • Max
Replace every N data points with the maximum value of the merged points.
  • Sum
Replace every N data points with the sum of the merged points.
  • SD
Replace every N data points with the standard derivation of the merged points.
Skip Columns

Only available when Reduce Method = Delete N Columns....

Starting Column to Delete/Merge

The starting column to merge/delete.

Output Worksheet

Specify output range.

For help with the range controls, see: Output Results