Band By 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 the mean and standard deviation of a data set, and then assigns a band number based upon each value's count of deviations from the mean.

Bands input rows by the number of unbiased standard deviations a row deviates from the mean. Bands are reported as positive integral values of the smallest number of standard deviations that contain the value. This band information is appended to the input data as an additional field on the first input.

Values that happen to be exactly the standard deviation, for situations when this does happen, are reported as being within one standard deviation of the mean rather than zero standard deviations from the mean. null values are placed in a band identified by the value null and are ignored for purposes of determining the standard deviation and mean.

Bands are reported as positive values in an additional field that is added to the input records.

The second output contains the unbiased standard deviation and mean of the input data. This information can be used to programmatically determine which side of the mean a particular values lies on. Please remember that these two values do not include any null values.

Properties

InputExpr

Specify the values used to calculate the mean, standard deviation, and bands for this node. This expression must evaluate to a single value that is either an integer, a double, or a long value.

This expression can convert data from one type to another. For example, it could convert two dates from two different fields into the number of days between those two dates.

A value is required for this property.

BandFieldName

Optionally specify the name of the field in which the band number is output. This value can be changed if you happen to have a field whose name is the same as this name or for any other purpose.

The default value is "_Band".

Inputs and outputs

Inputs: in1.

Outputs: Banded Data, Stats.