Standard Deviation (Superseded) - Data360_Analyze - 3 - 3.12

Data360 Analyze Server Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
3.12
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

Calculates standard deviation, average (mean), sum, and count statistics for the specified field.

The node outputs one row of data with four columns, as follows, where "FieldName" is the value of the ResultPrefix property, if it is specified, or the value of the InputField property if the ResultPrefix is not specified:

  • FieldNameStandardDeviation
  • FieldNameAverage
  • FieldNameCount
  • FieldNameSum

Properties

InputField

Specify the name of the field on which to calculate the statistics. The specified field must have a numeric data type.

A value is required for this property.

Biased

Optionally specify whether to calculate the sample standard deviation or the population standard deviation.

If set to True, the node calculates the population standard deviation.

If set to False, the node calculates the sample standard deviation.

The default value is False.

InputExpr

Optionally specify an expression on which to calculate the statistics. By default, this is the same as the InputField property, however, the InputExpr property may be used to change the InputField to a different data type or perform a calculation on it first. For example, if the field specified by the InputField property is a string data type, the values could be converted to a double data type prior to calculating the statistics by inserting the following value in the InputExpr property:

double( {{^InputField^}} )

ResultPrefix

Optionally specify the text to prepend to the column names that are output. For example, if this property is set to 'Prefix', the result fields would be PrefixStandardDeviation, PrefixAverage, PrefixCount and PrefixSum.

Inputs and outputs

Inputs: in1.

Outputs: out1.