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