Data Science SQL

Root mean squared error

SELECT SQRT(AVG(POWER(y - y_pred, 2))) AS rmse FROM ...

Mean absolute error

SELECT AVG(ABS(y - y_pred)) AS mae FROM ...

Mean error

SELECT AVG(y_pred - y) AS me FROM ...

Median - get it here


Published September 10, 2015

You might also enjoy

attr_accessible to Strong Parameters

navigator.sendBeacon and Rails

R and Database URLs

All code examples are public domain.
Use them however you’d like (licensed under CC0).