regr_sxy - ClickHouse Documentation

regr_sxy

Introduced in: v26.9.0 Returns the sum of products of the two variables:

\Sigma{(x - \bar{x})(y - \bar{y})}

Syntax

regr_sxy(y, x)

Aliases: regrSXY Arguments

y — Dependent variable. (U)Int* or Float*
x — Independent variable. (U)Int* or Float*

Returned value Returns the sum of products of x and y around their means. Float64 Examples Basic usage

Query

SELECT regr_sxy(y, x)
FROM VALUES('x Float64, y Float64', (1, 2), (2, 4), (3, 6), (4, 8))

Response

┌─regr_sxy(y, x)─┐
│             10 │
└────────────────┘

Last modified on October 7, 2026