Prediction Accuracy - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

This query displays the prediction accuracy:

SELECT (SELECT COUNT(*) FROM housing_prediction, housing_test
  WHERE housing_prediction.sn = housing_test.sn
  AND housing_prediction.pred_label =
    housing_test.homestyle) / (SELECT COUNT(SN) FROM housing_prediction)
  ) AS PA;
Single_Tree_Predict Example Prediction Accuracy
PA
0.98148148148148148148

The prediction accuracy is 98.1%, a large improvement over the Forest_Predict function, whose prediction accuracy is 77.7% on the same input.