regr_r2

Returns the coefficient of determination of the regression line.

regr_r2

Introduced in: v26.9.0

Returns the coefficient of determination of the least-squares fit, that is, the square of the correlation coefficient. Returns nan when x is constant, and 1 when y is constant.

Syntax

regr_r2(y, x)

Aliases: regrR2

Arguments

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

Returned value

Returns a value between 0 and 1. Float64

Examples

Basic usage

Query

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

Response

┌─regr_r2(y, x)─┐
│             1 │
└───────────────┘