Skip to main content
Skip to main content

REGR_SYY

Description

Syntax

double regr_syy(y, x)

x, y support basic numeric types.

calculates the sum of squares of deviations of the dependent variable Y from its mean

EXAMPLE

We have the following data

mysql> select * from t;
+------+------+------+
| id | x | y |
+------+------+------+
| 2 | 14 | 27 |
| 4 | 10 | 20 |
| 3 | 5 | 7 |
| 1 | 18 | 13 |
+------+------+------+
mysql> select regr_syy(y,x) from t;
+----------------+
| regr_syy(y, x) |
+----------------+
| 224.75 |
+----------------+

KEYWORDS

REGR_SYY