Band By Deviation - Data360_Analyze - 3.12

Data360 Analyze Server Help

Product
Data360 Analyze
Version
3.12
Language
English
Portfolio
Verify
Product family
Data360
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
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.

Values that happen to be exactly the standard deviation, 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.

In the Banded Data output, bands are reported as positive values in an additional field that is added to the input records.

The Statistics output contains the unbiased standard deviation and average of the input data, along with a count of the total number of records in the selected field. Note that the standard deviation and average values do not include any Null values. This information can be used to determine which side of the average a particular values lies on.

Properties

BandExpression

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, Statistics.