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

SELECT MEDIAN(y) FROM ...

Published September 10, 2015


You might also enjoy

Error Reporting in R

Learn Data Science

Rails on Dokku


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