simpleLinearRegression
Performs simple (unidimensional) linear regression.
simpleLinearRegression(x, y)
Parameters:
x
β Column with dependent variable values.y
β Column with explanatory variable values.
Returned values:
Constants (a, b)
of the resulting line y = a*x + b
.
Examples
SELECT arrayReduce('simpleLinearRegression', [0, 1, 2, 3], [0, 1, 2, 3])
ββarrayReduce('simpleLinearRegression', [0, 1, 2, 3], [0, 1, 2, 3])ββ
β (1,0) β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
SELECT arrayReduce('simpleLinearRegression', [0, 1, 2, 3], [3, 4, 5, 6])
ββarrayReduce('simpleLinearRegression', [0, 1, 2, 3], [3, 4, 5, 6])ββ
β (1,3) β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ