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