QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

ZTest_conf - script and chart function

ZTest_conf() returns the aggregated z value for a series of values.

If the function is used in the 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.

Syntax:  

ZTest_conf(value[, sigma[, sig]])

Return data type: numeric

Arguments:  

Argument Description
value The sample values to be evaluated. A population mean of 0 is assumed. If you want the test to be performed around another mean, subtract that mean from the sample values.
sigma If known, the standard deviation can be stated in sigma. If sigma is omitted the actual sample standard deviation will be used.
sig The two-tailed level of significance can be specified in sig. If omitted, sig is set to 0.025, resulting in a 95% confidence interval.

Limitations:  

Text values, NULL values and missing values in the expression value will result in the function returning NULL.

Example:  

ZTest_conf(Value-TestValue)

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?