ZTestw_sig() returns the aggregated z-test 2-tailed level of significance for a series of values.
This function applies to z-tests where the input data series is given in weighted two-column format.
If the function is used in the data load script, the values are iterated over a number of records as defined by a group by clause.
If the function is used in a chart expression, the values are iterated over the chart dimensions.
ZTestw_sig (weight, value [, sigma])
Return data type: numeric
|value||The values should be returned by value. A sample mean of 0 is assumed. If you want the test to be performed around another mean, subtract that value from the sample values.|
|weight||Each sample value in value can be counted one or more times according to a corresponding weight value in weight.|
|sigma||If known, the standard deviation can be stated in sigma. If sigma is omitted the actual sample standard deviation will be used.|
Text values, NULL values and missing values in the expression value will result in the function returning NULL.
ZTestw_sig( Weight, Value-TestValue)