IDAX.T_TEST_AGG - t-Student test of a variable that is split into two classes

The T_TEST_AGG stored procedure calculates the t-Student statistics of a numeric variable split into two classes.

Syntax

IDAX.T_TEST_AGG(INTEGER class, DOUBLE X)

Parameter descriptions

class: Mandatory.; The class (1 or 2) of the value of the input variable.; The classes can be of different size and the size values can have different variances.; Rows with a class other than 1 and 2 are ignored.; Min: 1; Max: 2; Data type: INTEGER
X: Mandatory.; The input variable.; Data type: DOUBLE

Returned information

DOUBLE the t-Student statistics for the two classes of the input variable.

Example

SELECT IDAX.T_TEST_AGG(case when class='setosa' then 1 when class='virginica' then 2 when class='versicolor'then 0 else 0 end,petallength) FROM IRIS;