v.22.10New Feature

Added analysisOfVariance (anova) Aggregate Function for Statistical Testing

Official CH changelog text
Added an aggregate function analysisOfVariance (anova) to perform a statistical test over several groups of normally distributed observations to find out whether all groups have the same mean or not. Original PR #37872. #42131 (Nikita Mikhaylov).
Added a new aggregate function analysisOfVariance (alias anova) to perform statistical tests that determine whether multiple groups of normally distributed data have the same mean.

Why it matters

This feature enables users to conduct ANOVA tests directly within ClickHouse to analyze variance across several groups. It helps identify if group means differ significantly, facilitating statistical analysis and decision-making without exporting data to external tools.

How to use it

Use the aggregate function analysisOfVariance or its alias anova in your SELECT statements to perform the ANOVA test on grouped data. For example:

SELECT anova(value_column) FROM table_name GROUP BY group_column;

Related resources

PreviousNext