analysisOfVariance

Introduced in: v22.10

Provides a statistical test for one-way analysis of variance (ANOVA test). It is a test over several groups of normally distributed observations to find out whether all groups have the same mean or not.

Note

Groups are enumerated starting from 0 and there should be at least two groups to perform a test. There should be at least one group with the number of observations greater than one.

Syntax

analysisOfVariance(val, group_no)

Aliases: anova

Arguments

val — Value. (U)Int* or Float* or Decimal
group_no — Group number that val belongs to. (U)Int* or Float* or Decimal

Returned value

Returns a tuple with the F-statistic and p-value. Tuple(Float64, Float64)

Examples

Basic usage

SELECT analysisOfVariance(number, number % 2) FROM numbers(1048575);

┌─analysisOfVariance(number, modulo(number, 2))─┐
│ (0,1)                                         │
└───────────────────────────────────────────────┘

analysisOfVariance​

analysisOfVariance