studentTTest
Applies Student’s t-test to samples from two populations.
Syntax
studentTTest(sample_data, sample_index)
Values of both samples are in the sample_data
column. If sample_index
equals to 0 then the value in that row belongs to the sample from the first population. Otherwise it belongs to the sample from the second population.
The null hypothesis is that means of populations are equal. Normal distribution with equal variances is assumed.
Arguments
Returned values
Tuple with two elements:
Example
Input table:
┌─sample_data─┬─sample_index─┐
│ 20.3 │ 0 │
│ 21.1 │ 0 │
│ 21.9 │ 1 │
│ 21.7 │ 0 │
│ 19.9 │ 1 │
│ 21.8 │ 1 │
└─────────────┴──────────────┘
Query:
SELECT studentTTest(sample_data, sample_index) FROM student_ttest;
Result:
┌─studentTTest(sample_data, sample_index)───┐
│ (-0.21739130434783777,0.8385421208415731) │
└───────────────────────────────────────────┘
See Also
当前内容版权归 ClickHouse 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ClickHouse .