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 │
└───────────────┘

SQL Reference

Data Types

Engines

Functions

Formats

Settings

System Tables

Data Lakes

regr_r2

regr_r2

​regr_r2

regr_r2