Moving Statistics

Author: O.Conrad (c) 2009
Menu: Table | Calculus

Description

For each record the statistics over the selected attribute and the specified number of records is calculated.

Parameters

	Name	Type	Identifier	Description	Constraints
Input	Input	table, input	`INPUT`	-	-
Output	Output	table, output, optional	`OUTPUT`	-	-
Options	Field	table field	`FIELD`	-	-
	Order by...	table field	`INDEX`	-	-
	Missing Records	choice	`MISSING`	Create output option. If 'complete' specified number of records must be found, 'in range' ignores no-data in found records.	Available Choices: [0] complete records [1] all records in range [2] all records Default: 0
	Offset	integer number	`OFFSET`	The number of preceding records to be taken into account for statistics.	Default: 5
	Number of Records	integer number	`LENGTH`	The total number of records to be taken into account for statistics.	Minimum: 1 Default: 11
	Mean	boolean	`MEAN`	-	Default: 1
	Mean	table field	`FIELD_MEAN`	-	-
	Median	boolean	`MEDIAN`	-	Default: 0
	Median	table field	`FIELD_MEDIAN`	-	-
	Minimum	boolean	`MIN`	-	Default: 0
	Minimum	table field	`FIELD_MIN`	-	-
	Maximum	boolean	`MAX`	-	Default: 0
	Maximum	table field	`FIELD_MAX`	-	-
	Standard Deviation	boolean	`STDV`	-	Default: 0
	Standard Deviation	table field	`FIELD_STDV`	-	-
	Lower Standard Deviation	boolean	`STDV_LO`	-	Default: 0
	Lower Standard Deviation	table field	`FIELD_STDV_LO`	-	-
	Higher Standard Deviation	boolean	`STDV_HI`	-	Default: 0
	Higher Standard Deviation	table field	`FIELD_STDV_HI`	-	-

Command Line


Usage: saga_cmd table_calculus 5 [-INPUT ] [-OUTPUT ] [-FIELD ] [-INDEX ] [-MISSING ] [-OFFSET ] [-LENGTH ] [-MEAN ] [-FIELD_MEAN ] [-MEDIAN ] [-FIELD_MEDIAN ] [-MIN ] [-FIELD_MIN ] [-MAX ] [-FIELD_MAX ] [-STDV ] [-FIELD_STDV ] [-STDV_LO ] [-FIELD_STDV_LO ] [-STDV_HI ] [-FIELD_STDV_HI ]
  -INPUT:           Input
	table, input
  -OUTPUT:          Output
	table, output, optional
  -FIELD:           Field
	table field
  -INDEX:           Order by...
	table field
  -MISSING:
                         Missing Records
                         	choice
                         	Available Choices:
                         	[0] complete records
                         	[1] all records in range
                         	[2] all records
                         	Default: 0
  -OFFSET:          Offset
	integer number
	Default: 5
  -LENGTH:          Number of Records
	integer number
	Minimum: 1
	Default: 11
  -MEAN:            Mean
	boolean
	Default: 1
  -FIELD_MEAN:      Mean
	table field
  -MEDIAN:          Median
	boolean
	Default: 0
  -FIELD_MEDIAN:    Median
	table field
  -MIN:             Minimum
	boolean
	Default: 0
  -FIELD_MIN:       Minimum
	table field
  -MAX:             Maximum
	boolean
	Default: 0
  -FIELD_MAX:       Maximum
	table field
  -STDV:            Standard Deviation
	boolean
	Default: 0
  -FIELD_STDV:      Standard Deviation
	table field
  -STDV_LO:         Lower Standard Deviation
	boolean
	Default: 0
  -FIELD_STDV_LO:   Lower Standard Deviation
	table field
  -STDV_HI:         Higher Standard Deviation
	boolean
	Default: 0
  -FIELD_STDV_HI:   Higher Standard Deviation
	table field