IDAX.T_LS_TEST_S_AGG - t-Student test between linearly dependent samples as a string

The T_LS_TEST_S_AGG stored procedure calculates the t-Student statistics of two numeric variables to evaluate the significance of the linear relationship between them.

Syntax

IDAX.T_LS_TEST_S_AGG(DOUBLE X, DOUBLE Y, DOUBLE Slope)

Parameter descriptions

X
Mandatory.
The first variable.
Data type: INTEGER
Y
Mandatory.
The second variable.
Data type: INTEGER
slope
Mandatory.
The constant value that indicates the expected direction of dependence Y=X*Slope+constant.
Data type: DOUBLE

Returned information

A string as VARCHAR(200) that contains the t-Student statistics, the degree of freedom, and the linear equation that relates to X and Y, and the variance of the equation.

Example

SELECT IDAX.T_LS_TEST_S_AGG(petallength,sepallength,1.5) FROM IRIS;