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 · Tweet


You might also enjoy

Introducing Dexter, the Automatic Indexer for Postgres POPULAR

A Short Guide to Metrics

Error Reporting in R


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