Skip to main content Skip to complementary content

TTest1w_upper - script and chart function

TTest1w_upper() returns the aggregated value for the upper end of the confidence interval for a series of values.

This function applies to one-sample student's t-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.

Syntax:  

TTest1w_upper (weight, value [, sig])

Return data type: numeric

Arguments:  

Arguments
Argument Description
value The samples to be evaluated. If a field name for the sample values is not provided in the load script, the field will automatically be named Value.
weight Each value in value can be counted one or more times according to a corresponding weight value in weight.
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.

Examples:  

TTest1w_upper( Weight, Value )

TTest1w_upper( Weight, Value, 0.005 )

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!