IDAX.T_TEST_S_AGG - t-Student test for a variable that is split into two classes

The T_TEST_S_AGG stored procedure calculates the t-Student statistics and the degree of freedom for an input variable the values of which are split into two classes.

Syntax

IDAX.T_TEST_S_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
mean: Mandatory.; A constant that indicates the expected mean value of the input variable.; Data type: DOUBLE

Returned information

A string as VARCHAR(200) that contains the t-Student statistics and the degree of freedom for the two classes of the input variable.

Example

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