O'Reilly logo

Practical Predictive Analytics by Ralph Winters

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Root-mean-square error (RMSE)

We have already computed the squared error from the data, so to compute the root-mean-square error (RMSE), all we need to do is call SQL in order to take the average squared error for each outcome. We can see that there is much more variation in predicted outcome=1 (diabetes) than there is for predicting outcome=0:

result <- sql("select outcome,avg(errorsqr) from preds_tbl group by 1")display(result)

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required