regr_syy

Returns the sum of squares of the dependent variable around its mean.

regr_syy

Introduced in: v26.9.0

Returns the sum of squares of the dependent variable:

$$\Sigma{(y - \bar{y})^2}$$

Syntax

regr_syy(y, x)

Aliases: regrSYY

Arguments

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

Returned value

Returns the sum of squares of y around its mean. Float64

Examples

Basic usage

Query

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

Response

┌─regr_syy(y, x)─┐
│             20 │
└────────────────┘